--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')