web第三题建数据库、建表

最新推荐文章于 2024-10-02 00:27:17 发布

deft020513

最新推荐文章于 2024-10-02 00:27:17 发布

阅读量186

点赞数 2

文章标签：数据库 sql mysql

本文链接：https://blog.csdn.net/deft020513/article/details/139674678

版权

表1

CREATE TABLE [dbo].[Category] (

[CategoryId] INT IDENTITY (1, 1) NOT NULL,

[Name] NVARCHAR (80) NULL,

[Descn] NVARCHAR (255) NULL,

PRIMARY KEY CLUSTERED ([CategoryId] ASC)

);

表2

CREATE TABLE [dbo].[Product] (

[ProductId] INT IDENTITY (1, 1) NOT NULL,

[CategoryId] INT NOT NULL,

[ListPrice] DECIMAL (10, 2) NULL,

[UnitCost] DECIMAL (10, 2) NULL,

[SuppId] INT NULL,

[Name] NVARCHAR (80) NULL,

[Descn] NVARCHAR (255) NULL,

[Image] NVARCHAR (80) NULL,

[Qty] INT NOT NULL,

PRIMARY KEY CLUSTERED ([ProductId] ASC),

FOREIGN KEY ([CategoryId]) REFERENCES [dbo].[Category] ([CategoryId]),

);

CREATE TABLE [dbo].[Category] (
    [CategoryId] INT            IDENTITY (1, 1) NOT NULL,
    [Name]       NVARCHAR (80)  NULL,
    [Descn]      NVARCHAR (255) NULL,
    PRIMARY KEY CLUSTERED ([CategoryId] ASC)
);

CREATE TABLE [dbo].[Product] (
    [ProductId]  INT             IDENTITY (1, 1) NOT NULL,
    [CategoryId] INT             NOT NULL,
    [ListPrice]  DECIMAL (10, 2) NULL,
    [UnitCost]   DECIMAL (10, 2) NULL,
    [SuppId]     INT             NULL,
    [Name]       NVARCHAR (80)   NULL,
    [Descn]      NVARCHAR (255)  NULL,
    [Image]      NVARCHAR (80)   NULL,
    [Qty]        INT             NOT NULL,
    PRIMARY KEY CLUSTERED ([ProductId] ASC),
    FOREIGN KEY ([CategoryId]) REFERENCES [dbo].[Category] ([CategoryId]),
    
);