受注用のテーブルを作成
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)
)