netbarcreatetable.sql

swing+jdbc+sqlserver2000的小型网吧系统

--1.会员信息表(会员卡号,卡号密码,卡号余额,会员名称,身份证号,注册日期,卡号状态[0:未使用;1:使用],上次登录时间)
create table customer
(
	cusCardNum varchar(16) not null primary key, 
	cusCardPassword varchar(16) not null,
	cusBalance varchar(16) not null,
	cusName varchar(16) not null,
	cusPersonID varchar(18) not null,
	cusRegDate varchar(20)not null,
	cusCardState varchar(2) not null,
	cusLastLoginTime varchar(20)
)


--2.机器表(机器编号,机器类型,机器状态[0:空闲;1:使用中;2:待修])
create table pc
(
	pcNum varchar(16) not null primary key,
	pcType varchar(4) not null,
	pcState varchar(2) not null
)

--3.消费信息表(自增列,机器号码,会员卡号,会员名称,上机时间,下机时间,消费金额,当前余额)
create table consume
(	
	conID int not null identity(1,1) primary key,
	conPCNum varchar(16) not null, 
	conCardNum varchar(16) not null ,
	conName varchar(16) not null,
	conStartTime varchar(20) not null,
	conEndTime varchar(20),
	conMoney varchar(10),
	conCurrentBalance varchar(10)
)


--4.冲值表(会员卡号,冲值金额,冲值日期)
create table addMoney
(
	addID int not null identity(1,1) primary key,
	addCusCardNum varchar(16) not null,
	addAmount varchar(10) not null,
	addDate varchar(20) not null
)

--5.系统用户表(用户名,用户密码)[默认都为admin]
create table systemUsers
(
	sysUsername varchar(16) not null primary key,
	sysPassword varchar(16)
)

insert into systemUsers values('admin','admin')