同样是图7.3中类继承关系,采用每个子类保存为一个表的策略时,需要创建5个表。创建表的SQL脚本如下所示:
/*员工表*/
CREATE TABLE tb_employee (
id int(20) NOT NULL auto_increment,
name varchar(255) ,
employee_type varchar(32),
PRIMARY KEY (id)
);
/*正式员工表*/
CREATE TABLE tb_regular_employee (
id int(20) NOT NULL auto_increment,
vacation_days int(10),
PRIMARY KEY (id)
);
/*合同员工表*/
CREATE TABLE tb_contract_employee (
id int(20) NOT NULL auto_increment,
create_date date,
expired_date date,
PRIMARY KEY (id)
);
/*全职员工表*/
CREATE TABLE tb_fulltime_employee (
id int(20) NOT NULL auto_increment,
monthly_salary double(10,2),
PRIMARY KEY (id)
);
/*兼职员工表*/
CREATE TABLE tb_parttime_employee (
id int(20) NOT NULL auto_increment,
hourly_salary double(10,2),
worked_hours int(10),
PRIMARY KEY (id)
);