[Memo][SQLServer2008] テスト用テーブルのメモ

受注用のテーブルを作成

create table dbo.T_JUCHU (
    ID              int IDENTITY(1,1)   NOT NULL,
    JNO             char(8)             NOT NULL,
    SHOHIN_CODE     varchar(10)         NOT NULL,
    TOKUISAKI_CODE  char(5)             NOT NULL,
    SURYO           int                 NOT NULL,
    TANKA           decimal             NOT NULL,
    KINGAKU         decimal             NOT NULL,
    CONSTRAINT  T_JUCHU_PK PRIMARY KEY (ID),
    CONSTRAINT  T_JUCHU_UK UNIQUE (JNO)
)

商品用のマスタテーブルを作成

create table dbo.M_SHOHIN (
    ID          int         IDENTITY(1,1)   NOT NULL,
    CODE        char(10)                    NOT NULL,
    NAME        nvarchar(30),
    BUNRUI_CODE char(3)                     NOT NULL,
    TANKA       decimal                     NOT NULL,
    CONSTRAINT  M_SHOHIN_PK PRIMARY KEY (ID),
    CONSTRAINT  M_SHOHIN_UK UNIQUE (CODE)
)

分類のマスタテーブルを作成

create table dbo.M_BUNRUI (
    ID          int         IDENTITY(1,1)   NOT NULL,
    CODE        char(3)                     NOT NULL,
    NAME        nvarchar(30),
    CONSTRAINT  M_BUNRUI_PK PRIMARY KEY (ID),
    CONSTRAINT  M_BUNRUI_UK UNIQUE (CODE)
)