继续建表语句.txt

来自「刚用java做的网上购物车 做毕业论文用的 有需要的朋友可以参考下」· 文本 代码 · 共 101 行

每个具体类对应一个表：
drop table companys;
create table companys(
    id    bigint    primary key,
    name  varchar(10)
);

drop table hourly_employees;
create table hourly_employees(
    id    bigint    primary key,
    name  varchar(10),
    rate  double,
    company_id    bigint  
                  references    companys(id)
);

drop table salaried_employees;
create table salaried_employees(
    id    bigint    primary key,
    name  varchar(10),
    salary  double,
    company_id    bigint  
                  references    companys(id)
);

-----------------------------------------------
根类对应一个表：
drop table companys;
create table companys(
    id    bigint    primary key,
    name  varchar(10)
);
drop table employees;
create table employees(
    id    bigint    primary key,
    employee_type varchar(10),
    name    varchar(10),
    rate    double,
    salary    double,
    company_id    bigint 
                  references   companys(id) 
);
-----------------------------------------------
每个类对应一个表:
drop table companys;
create table companys(
    id    bigint   primary key,
    name  varchar(10)
);

drop table employees;
create table employees(
    id    bigint   primary key,
    name  varchar(10),
    company_id    bigint
                  references    companys(id)
); 
drop table salaried_employees;
create table salaried_employees(
    employee_id    bigint    primary key,
    salary    double,
    constraint foreign key(employee_id)
    references employees(id)
);
drop table hourly_employees;
create table hourly_employees(
    employee_id    bigint    primary key,
    rate    double,
    constraint foreign key(employee_id)
    references employees(id)
);