酒店管理系统源码及数据库各个表的设计图及设计源码

BookingTb1

 CREATE TABLE [dbo].[BookingTb1] (
    [BId]     INT  IDENTITY (1, 1) NOT NULL,
    [BDate]   DATE NOT NULL,
    [BRoom]   INT  NOT NULL,
    [Agent]   INT  NOT NULL,
    [Datein]  DATE NOT NULL,
    [Dateout] DATE NOT NULL,
    [Amount]  INT  NOT NULL,
    PRIMARY KEY CLUSTERED ([BId] ASC),
    CONSTRAINT [FK2] FOREIGN KEY ([BRoom]) REFERENCES [dbo].[RoomTb1] ([RId]) ON DELETE CASCADE,
    CONSTRAINT [FK3] FOREIGN KEY ([Agent]) REFERENCES [dbo].[UserTb1] ([UId]) ON DELETE CASCADE
);

CategoryTb1

CREATE TABLE [dbo].[CategoryTb1] (
    [CatId]      INT           IDENTITY (100, 1) NOT NULL,
    [CatName]    NVARCHAR