EmployeeID varchar2 (6) not null, primary key, employee number
Name varchar2 (10) not null, - Name
Birthday date is not null, date of birth
Sex varchar2 (2) not null, gender
-Address varchar2 (20) not null, Address
-Zip varchar2 (6), - Zip
Phonenumber varchar2 (12), - phone number
Emailaddress varchar (30), - email
DeparmentID varchar2 (3) the not null constraint fk_employees_departments_departtmentID foreign key references the Departments (departmentID) - employee department
)
The create table the Departments (
DepartmentID varchar2 (3) not null, primary key, department number
DepartmentName varchar2 (20) not null, no. - department
Note varchar2 (16) - note
)
CodePudding user response:
Fk_employees_departments_departtmen, is too long, short name,CodePudding user response:
Foreign key fk_employees_departments_departtmentID name is too long, beyond the length of the Oracle support, to shorten points, suggested below 30 characters,