高校餐饮一卡通系统源码

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[card]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[card] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[card_use]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[card_use] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[casual_card_use]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[casual_card_use] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[employee]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[employee] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[student]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[student] GO CREATE TABLE [dbo].[card] ( [card_id] [char] (5) COLLATE Chinese_PRC_CI_AS NOT NULL , [user_id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [create_date] [datetime] NULL , [money] [float] NULL , [state] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[card_use] ( [card_use_id] [int] NOT NULL , [card_id] [char] (5) COLLATE Chinese_PRC_CI_AS NULL , [money] [float] NULL , [use_date] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[casual_card_use] ( [card_id] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [money] [float] NULL , [use_date] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[employee] ( [account] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [password] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[student] ( [user_id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [name] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [age] [decimal](18, 0) NULL , [address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO