文档介绍:构成
产品编号cha「(9)
零件号 cha「⑼
产品 产品编号ch嗣'
制成
零件号cha「(听'
编号 char⑼
称格产
名价生
varchar(40) numeric(2) datetime
零件
零件号cha /
create table MAKE (
PNUM char(9) not null,
MNUM char(9) not null,
constraint PK_MAKE primary key (PNUM, MNUM) ) go
/* ———————=———=——————————==—=———=——=—==—————————————————— * /
/* Index: RELATION_44_FK2 */
/* =============================== * / create index RELATION_44_FK2 on MAKE (PNUM)
go go
Index: RELATION 44 FK
*/
/*
/*/*
create index RELATION_44_FK on MAKE (MNUM)
*/
*/
/‘
/* Table: STORE2
/*
*/
create table STORE2
MNUM
char(9)
not null,
MSTORNUM
char(8)
not null,
constraint PK_STORE2 primary key (MNUM, MSTORNUM) ) go
Index: RELATION 45 FK2
*/
create index RELATION_45_FK2 on STORE2 (MNUM) go
*/
Index: RELATION_45_FK create index RELATION_45_FK on STORE2 (MSTORNUM) go
/* =============================== * / /* Table: STORE1 */
/* =============================== * / create table STORE 1 (
PNUM char(9) not null,
SNUM char(9) not null,
constraint PK_STORE1 primary key (PNUM, SNUM) ) go
/* =============================== * /
/* Index: RELATION_46_FK2 */
/* =============================== * / create index RELATION_46_FK2 on STORE1 (PNUM)
go
/* =============================== * /
/* Index: RELATION_46_FK */
/* ———————=———=——————————==—=———=——=—==—————————————————— * / create index RELATION