第四天练习

CREATE TABLE offices(

officeCode INT(10) PRIMARY KEY NOT NULL UNIQUE,

city VARCHAR(50) NOT NULL,

address VARCHAR(50),

country VARCHAR(50) NOT NULL,

postalCode VARCHAR(15) UNIQUE

)ENGINE=INNODB CHARSET=utf8mb4;

CREATE TABLE employees(

employeeNumber INT(11) PRIMARY KEY NOT NULL UNIQUE auto_increment,

lastName VARCHAR(50) NOT NULL,

firstName VARCHAR(50) NOT NULL,

mobile VARCHAR(25) UNIQUE,

officeCode INT(10) NOT NULL,

jobTitle VARCHAR(50) NOT NULL,

birth datetime NOT NULL,

note VARCHAR(255),

sex VARCHAR(5),

CONSTRAINT fk_employees_offices FOREIGN KEY(officeCode) REFERENCES offices(officeCode)

)ENGINE=INNODB CHARSET=utf8mb4;