银行计算机管理系统实例

create database bank default character set gbk; use bank; create table emp( id int auto_increment primary key, workId int, name varchar(20), sex varchar(20), birthday datetime, department varchar(20), jobName varchar(20), password varchar(20) )engine=innodb default charset=gbk; create table unit( id int auto_increment primary key, unitId int, unitName varchar(20), upUnit varchar(20), unitDemo text )engine=innodb default charset=gbk; create table dep( id int auto_increment primary key, departmentId int, departmentName varchar(20), departmentUnit varchar(20), departmentType int )engine=innodb default charset=gbk; create table comp( id int auto_increment primary key, numberID int, computerType varchar(20), cpu varchar(20), memory varchar(20), harddisk varchar(20), os varchar(20), mend varchar(20), antiVirus varchar(20), ipAddress varchar(20), macAddress varchar(20), userID int, userName varchar(20), userUnit varchar(20), houseID varchar(20), dutyPeople varchar(20), uses varchar(20), buyTime date, useTime date, whichUse varchar(20) )engine=innodb default charset=gbk; create table article( art_id int auto_increment primary key, art_title varchar(20), art_title2 varchar(20), art_abstract varchar(20), author_id varchar(20), author_name varchar(20), deliver_time varchar(20), art_content text )engine=innodb default charset=gbk;