畢業(yè)設(shè)計（論文）--辦公室日常管理信息系統(tǒng)開發(fā)-全文預(yù)覽
【正文】 表 37 查詢 Query 的結(jié)構(gòu) 管理表如圖 表 38 管理 Manage 的結(jié)構(gòu) 四 數(shù)據(jù)庫的實施 41 創(chuàng)建數(shù)據(jù)庫 create database YSS 創(chuàng)建表 創(chuàng)建職工表 Workers create table Workers W_ID char 20 primary key W_name char 8 not null W_sex char 2 W_age smallint W_job char 10 not null W_salary float 20 W_branch char 10 not null W_phone char 20 not null unique 創(chuàng)建會議表 Meeting create table Meeting M_ID char 20 primary key M_name char 20 not null M_participant char 100 not null M_content char 1000 not null M_recorder char 8 not null M_time datetime M_place char 20 創(chuàng)建文件表 Files create table Files F_name char 20 not null F_ID char 20 not null primary key F_kinds char 10 F_recorder char 8 not null F_level char 10 F_position char 10 創(chuàng)建管理員表 Administrator create table Administrator Ad_ID char 20 not null primary key Ad_password char 20 not null Ad_name char 8 創(chuàng)建考勤表 Attendance create table Attendance W_ID char 20 Ad_ID char 20 At_date datetime not null primary key At_late char 2 not null check At_late in YN At_quit char 2 not null check At_quit in YN foreign key W_ID references Workers W_ID foreign key Ad_ID references Administrator Ad_ID 創(chuàng)建事務(wù)管理表 Affairs create table Affairs Af_NO char 10 not null primary key Af_date datetime Af_recorder char 8 Af_events char 1000 創(chuàng)建查詢表 Query create table query W_ID char 20 F_ID char 20 primary key W_ID foreign key W_ID references Workers W_ID foreign key F_ID references Files F_ID 創(chuàng)建管理表 Manage create table Manage Ad_ID char 20 W_ID char 20 M_ID char 20 Af_NO char 10 F_ID char 20 primary key Ad_ID foreign key W_ID references Workers W_ID foreign key M_ID references Meeting M_ID foreign key Af_NO references Affairs Af_NO foreign key F_ID references Files F_ID foreign key Ad_ID references Administrator Ad_ID 引 create index W_ID on Workers W_ID asc create index F_ID on Files F_ID asc
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1