Description: /* Table: SALARY_SET, Owner: MISDBA*/
CREATE TABLE SALARY_SET (PERSON CHAR(6) NOT NULL,
SALARY FLOAT,
CONSTRAINT SALARY_SET_PEROSN PRIMARY KEY (PERSON))
/* Table: SALARY_OTHER, Owner: MISDBA*/
CREATE TABLE SALARY_OTHER (ID INTEGER NOT NULL,
YEARMONTH CHAR(7) NOT NULL,
PERSON CHAR(6) NOT NULL,
OTHER_TYPE CHAR(1) NOT NULL,
NAME VARCHAR(10) NOT NULL,
MONEY FLOAT,
DESCRIPTION VARCHAR(200),
CONSTRAINT SALARY_OTHER_ID PRIMARY KEY (ID))
/* Table: OTHER_TYPE, Owner: MISDBA*/
CREATE TABLE OTHER_TYPE (CODE CHAR(1) NOT NULL,
DESCRIPTION VARCHAR(10) NOT NULL,
CONSTRAINT TYPE_CODE PRIMARY KEY (CODE))
/* Table: SALARY, Owner: MISDBA*/
CREATE TABLE SALARY (ID INTEGER NOT NULL,
YEARMONTH CHAR(7) NOT NULL,
PERSON CHAR(6) NOT NULL,
BASIC FLOAT,
BONUS FLOAT,
ADD_DETAIL VARCHAR(200),
ADD_TOTAL FLOAT,
SUB_DETAIL VARCHAR(200),
SUB_TOTAL FLOAT,
To Search:
File list (Check if you may need any files):
Delphi版工资发放管理系统\source_code\crypt.dcu
........................\...........\crypt.pas
........................\...........\formula.ini
........................\...........\Salary.cfg
........................\...........\Salary.dof
........................\...........\Salary.dpr
........................\...........\Salary.res
........................\...........\u_datamodule.dcu
........................\...........\u_datamodule.ddp
........................\...........\u_datamodule.dfm
........................\...........\u_datamodule.dti
........................\...........\u_datamodule.pas
........................\...........\u_formula.dcu
........................\...........\u_formula.dfm
........................\...........\u_formula.pas
........................\...........\u_login.dcu
........................\...........\u_login.ddp
........................\...........\u_login.dfm
........................\...........\u_login.pas
........................\...........\u_main.dcu
........................\...........\u_main.ddp
........................\...........\u_main.dfm
........................\...........\u_main.pas
........................\...........\u_report.dcu
........................\...........\u_report.ddp
........................\...........\u_report.dfm
........................\...........\u_report.pas
........................\SQL7.txt
........................\source_code
Delphi版工资发放管理系统
Download