【正文】 表31 卡信息表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是cardid卡編號(hào)varchar20是否cardno卡號(hào)varchar20是否cardtype卡類型varchar20是否cardmoney余額money8是否sendtime發(fā)卡時(shí)間datetime8是否activetime有效時(shí)間datetime8是否sendflag已發(fā)tinyint1是否loseflag掛失tinyint1是否表32 停車場(chǎng)參數(shù)表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是parkname停車場(chǎng)名字varchar20是否parktotal總車位int4是否entertotal入口車道數(shù)int4是否exittotal出口車道數(shù)int4是否parktel停車場(chǎng)電話varchar20是否parkadd停車場(chǎng)地址varchar20是否表33 用戶表字段名描述類型長(zhǎng)度是否為空是否主鍵id編號(hào)varchar20否是name用戶名varchar20是否sex性別char2是否tel電話varchar20是否cardno卡號(hào)varchar20是否carno車牌varchar20是否address地址varchar20是否表34 車信息表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是carid編號(hào)varchar20否是carno車牌號(hào)varchar20是否cartype車類型varchar20是否表35 權(quán)限表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是poperatorid編號(hào)varchar20否是poperatorname姓名varchar20是否poperatorsex性別char10是否poperatorpsw密碼varchar20是否poperatorright權(quán)限varchar20是否表36時(shí)收費(fèi)表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是timeno時(shí)間號(hào)int4否是starttime開(kāi)始時(shí)間char10是否endtime結(jié)束時(shí)間char20是否表37 次收費(fèi)表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是times_no時(shí)間號(hào)int4否是starttime開(kāi)始時(shí)間char10是否endtime結(jié)束時(shí)間char10是否表38 入場(chǎng)表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是encardid入場(chǎng)編號(hào)varchar20否否encardno卡號(hào)varchar20是否encarno車牌varchar20是否enway入場(chǎng)車道varchar20是否entime入場(chǎng)時(shí)間datetime8是否enposition指定車位varchar20是否表39 出場(chǎng)表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是exited出場(chǎng)編號(hào)varchar20否否excardno卡號(hào)varchar20是否excarno車牌varchar20是否exway出場(chǎng)車道varchar20是否extime出場(chǎng)時(shí)間datetime8是否表310 交班表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是tnoperator操作員varchar20否否tnlogintime登錄時(shí)間datetime8是否tnturntime交班時(shí)間datetime8是否entimes進(jìn)場(chǎng)次數(shù)int4是否extimes出場(chǎng)次數(shù)int4是否totalmoney金額總計(jì)money8是否表311 收費(fèi)表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是chargeid收費(fèi)編號(hào)varchar20否否chcardno卡號(hào)varchar20是否chcarno車牌varchar20是否chmoney收費(fèi)金額money8是否表312 車位表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是cpcarno車牌varchar20是否positionstate車位狀態(tài)varchar20是否表313 收費(fèi)標(biāo)準(zhǔn)表字段名描述類型長(zhǎng)度是否為空是否主鍵id自增int4否是chargestid標(biāo)準(zhǔn)編號(hào)int4是否cardtype卡類型varchar20是否cartype車類型varchar20是否chargetype收費(fèi)類型varchar20是否timeno時(shí)間編號(hào)int4是否unittime單位時(shí)間int4是否unitsum單位金額int4是否mostsum最大金額int4是否 數(shù)據(jù)庫(kù)的實(shí)現(xiàn)腳本1 卡信息表CREATE TABLE [dbo].[pcard] ([id] [int] IDENTITY (1, 1) NOT NULL ,[cardid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[cardno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[cardtype] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[cardmoney] [money] NULL ,[sendtime] [datetime] NULL ,[activetime] [datetime] NULL ,[sendflag] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,[loseflag] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]2 停車場(chǎng)參數(shù)表CREATE TABLE [dbo].[parkparameter] ([id] [int] IDENTITY (1, 1) NOT NULL ,[parkname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,[parktotal] [int] NULL ,[entertotal] [int] NULL ,[exittotal] [int] NULL ,[parkadd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[parktel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]3 用戶表CREATE TABLE [dbo].[users] ([id] [int] IDENTITY (1, 1) NOT NULL ,[userid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[username] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[usersex] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[usertel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[u_carid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[u_cardid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[useradd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]4 車信息表CREATE TABLE [dbo].[car] ([id] [int] IDENTITY (1, 1) NOT NULL ,[carid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[carno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[cartype] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]5 權(quán)限表CREATE TABLE [dbo].[rateright] ([id] [int] IDENTITY (1, 1) NOT NULL ,[poperatorid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[poperatorname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[poperatorsex] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,[poperatorright] [varchar] (20) COLLA