【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,bsp_my_spl_contact.sql,希望对大家有所帮助!
create table bspdb.BSP_MY_SPL_CONTACT(
MY_ID VARCHAR(20) not null,
CONT_ID VARCHAR(20) not null,
FNAME VARCHAR(20) not null,
LNAME VARCHAR(20) ,
CORP_ID VARCHAR(5) not null,
TELNUM VARCHAR(15) ,
MPHONE VARCHAR(15) ,
UADD VARCHAR(200) ,
POSTCODE VARCHAR(8) ,
EMAIL VARCHAR(30) ,
FUNAME_CN VARCHAR(20),
CDATE DATE not null,
UDATE DATE not null,
FAXNUM VARCHAR(15) ,
constraint SQL080505021443100 primary key (MY_ID,CONT_ID)
);
alter table bspdb.BSP_MY_SPL_CONTACT
add constraint FKF25CE95D6B3512F9
foreign key (CORP_ID)
references bspdb.BSP_CORP(CORP_ID);