dbbatchsql.sql

来自「J2EE编程实例」· SQL 代码 · 共 21 行

CREATE TABLE EMPLOYEETBL
(
   EMPLOYEE_ID VARCHAR(8) NOT NULL,
   NAME VARCHAR(30),
   PRIMARY KEY(EMPLOYEE_ID)
);

CREATE TABLE WALFARETBL
(
   WALFARE_ID VARCHAR(8) NOT NULL,
   NAME VARCHAR(30),
   PRIMARY KEY(WALFARE_ID)    
);

CREATE TABLE ENROLLTBL
(
   EMPLOYEE_ID VARCHAR(8) NOT NULL,
   WALFARE_ID VARCHAR(8) NOT NULL,
   PRIMARY KEY(EMPLOYEE_ID,WALFARE_ID)   
);