sqlcommand.txt

来自「本文件中还有JSP、php和delphi等源程序」· 文本 代码 · 共 109 行

/* Table: CHECKTIMERECORD, Owner: SYSDBA */

CREATE TABLE "CHECKTIMERECORD" 
(
  "ID"	CHAR(10) NOT NULL,
  "RECORDTIME"	TIMESTAMP NOT NULL,
  "RECORDTYPE"	CHAR(20) NOT NULL,
  "RESULT"	CHAR(10) NOT NULL,
  "TIMECOUNT"	DOUBLE PRECISION NOT NULL,
  "SALARY"	DOUBLE PRECISION NOT NULL
);

/* Table: DEPARTMENT_TABLE, Owner: SYSDBA */

CREATE TABLE "DEPARTMENT_TABLE" 
(
  "ID"	CHAR(10) NOT NULL,
  "DEPARTMENT_NAME"	CHAR(20) NOT NULL,
  "DEPARTMENT_MASTER_ID"	CHAR(10) NOT NULL,
  "DEPARTMENT_SUBSIDY"	DOUBLE PRECISION NOT NULL,
  "DESCRIPTION"	VARCHAR(50)
);

/* Table: HOLIDAY_TABLE, Owner: SYSDBA */

CREATE TABLE "HOLIDAY_TABLE" 
(
  "PERSON_ID"	CHAR(10) NOT NULL,
  "HOLIDAY_REASON"	CHAR(16) NOT NULL,
  "STARTTIME"	TIMESTAMP NOT NULL,
  "ENDTIME"	TIMESTAMP NOT NULL,
  "OPERATOR"	CHAR(10) NOT NULL,
  "DESCRIPTION"	VARCHAR(50),
  "TIMECOUNT"	DOUBLE PRECISION NOT NULL,
  "SALARY"	DOUBLE PRECISION NOT NULL
);

/* Table: OPERATOR_TABLE, Owner: SYSDBA */

CREATE TABLE "OPERATOR_TABLE" 
(
  "ID"	CHAR(10) NOT NULL,
  "OPERATOR_NAME"	CHAR(10) NOT NULL,
  "OPERATOR_PASSWORD"	CHAR(30) NOT NULL,
  "OPERATOR_RIGHTS"	CHAR(30) NOT NULL,
  "DESCRIPTION"	VARCHAR(50)
);

/* Table: OVERTIME_TABLE, Owner: SYSDBA */

CREATE TABLE "OVERTIME_TABLE" 
(
  "PERSON_ID"	CHAR(10) NOT NULL,
  "START_TIME"	TIMESTAMP NOT NULL,
  "END_TIME"	TIMESTAMP NOT NULL,
  "OPERATOR"	CHAR(10) NOT NULL,
  "DESCRIPTION"	VARCHAR(50),
  "TIMECOUNT"	DOUBLE PRECISION NOT NULL,
  "SALARY"	DOUBLE PRECISION NOT NULL
);

/* Table: PERSON_TABLE, Owner: SYSDBA */

CREATE TABLE "PERSON_TABLE" 
(
  "ID"	CHAR(10) NOT NULL,
  "PERSON_NAME"	CHAR(10) NOT NULL,
  "PERSON_PASSWORD"	CHAR(30) NOT NULL,
  "PERSON_SEX"	CHAR(30) NOT NULL,
  "PERSON_BIRTHDAY"	TIMESTAMP NOT NULL,
  "PERSON_WORKDATE"	TIMESTAMP NOT NULL,
  "DEPARTMENT"	CHAR(20) NOT NULL,
  "JOB"	CHAR(20) NOT NULL,
  "BASE_SALARY"	DOUBLE PRECISION NOT NULL,
  "ADDRESS"	CHAR(50),
  "TEL"	CHAR(15),
  "OTHER_SALARY1"	DOUBLE PRECISION,
  "OTHER_SALARY2"	DOUBLE PRECISION,
  "DESCRIPTION"	VARCHAR(50)
);

/* Table: SALARY_TABLE, Owner: SYSDBA */

CREATE TABLE "SALARY_TABLE" 
(
  "ID"	CHAR(10) NOT NULL,
  "PERSON_ID"	CHAR(10) NOT NULL,
  "PERSON_NAME"	CHAR(10) NOT NULL,
  "BASE_SALARY"	DOUBLE PRECISION NOT NULL,
  "DEPARTMENT_SALARY"	DOUBLE PRECISION NOT NULL,
  "VOCATION_SALARY"	DOUBLE PRECISION NOT NULL,
  "OTHER_SALARY1"	DOUBLE PRECISION,
  "OTHER_SALARY2"	DOUBLE PRECISION,
  "BONUS"	DOUBLE PRECISION NOT NULL,
  "MULCT"	DOUBLE PRECISION NOT NULL,
  "SHOULD_PAY_SALARY"	DOUBLE PRECISION NOT NULL,
  "REAL_PAY_SALARY"	DOUBLE PRECISION NOT NULL,
  "IS_PAY"	INTEGER NOT NULL
);

/* Table: VOCATION_TABLE, Owner: SYSDBA */

CREATE TABLE "VOCATION_TABLE" 
(
  "ID"	CHAR(10) NOT NULL,
  "VOCATION_NAME"	CHAR(16) NOT NULL,
  "VOCATION_SUBSIDY"	DOUBLE PRECISION NOT NULL,
  "DESCRIPTION"	VARCHAR(50)
);