基于web的停車(chē)場(chǎng)管理系統(tǒng)設(shè)計(jì)和實(shí)現(xiàn)-在線(xiàn)瀏覽
2024-08-02 17:32本頁(yè)面
【正文】 8是否表310 交班表字段名描述類(lèi)型長(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)表字段名描述類(lèi)型長(zhǎng)度是否為空是否主鍵id自增int4否是chargeid收費(fèi)編號(hào)varchar20否否chcardno卡號(hào)varchar20是否chcarno車(chē)牌varchar20是否chmoney收費(fèi)金額money8是否表312 車(chē)位表字段名描述類(lèi)型長(zhǎng)度是否為空是否主鍵id自增int4否是cpcarno車(chē)牌varchar20是否positionstate車(chē)位狀態(tài)varchar20是否表313 收費(fèi)標(biāo)準(zhǔn)表字段名描述類(lèi)型長(zhǎng)度是否為空是否主鍵id自增int4否是chargestid標(biāo)準(zhǔn)編號(hào)int4是否cardtype卡類(lèi)型varchar20是否cartype車(chē)類(lèi)型varchar20是否chargetype收費(fèi)類(lè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ē)場(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 用戶(hù)表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 車(chē)信息表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) COLLATE Chinese_PRC_CI_AS NULL ,[poperatorpsw] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]6 時(shí)收費(fèi)表CREATE TABLE [dbo].[ptime] ([id] [int] IDENTITY (1, 1) NOT NULL ,[timeno] [int] NOT NULL ,[timestart] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[timeend] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]7 次收費(fèi)表CREATE TABLE [dbo].[ptimes] ([id] [int] IDENTITY (1, 1) NOT NULL ,[timesno] [int] NOT NULL ,[timesstart] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,[timesend] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]8 入場(chǎng)表CREATE TABLE [dbo].[entrance] ([id] [int] IDENTITY (1, 1) NOT NULL ,[encardno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[encardtype] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[encarno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[encartype] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[enway] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[entime] [datetime] NULL ,[enposition] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[enchargetype] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[enoperator] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]9 出場(chǎng)表CREATE TABLE [dbo].[pexit] ([id] [int] IDENTITY (1, 1) NOT NULL ,[excardno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[excarno] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[exway] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[extime] [datetime] NULL ) ON [PRIMARY]10 交班表CREATE TABLE [dbo].[turn] ([id] [int] IDENTITY (1, 1) NOT NULL ,[tnoperator] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[tnlogintime] [datetime] NULL ,[tnturntime] [datetime] NULL ,[entimes] [int] NULL ,[extimes] [int] NULL ,[totalmoney] [money] NULL ) ON [PRIMARY]11 收費(fèi)表CREATE TABLE [dbo].[charge] ([id] [int] IDENTITY (1, 1) NOT NULL ,[cardid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[cardtype] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[cartype] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[carn
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1