【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了bsp_user.sql提供大家参考,希望对大家有所帮助!
create table bspdb.BSP_USER(
USERNBR VARCHAR(20) not null,
FNAME VARCHAR(20) not null,
LNAME VARCHAR(20) ,
TELNUM VARCHAR(15) not null,
MPHONE VARCHAR(12) not null,
UADD VARCHAR(100) ,
POSTCODE VARCHAR(10) not null,
EMAIL VARCHAR(30) not null,
PASSWORD VARCHAR(10) not null,
AST VARCHAR(1) not null,
CORP_ID VARCHAR(5) not null,
CLAIM_TXT VARCHAR(3000) ,
ROLE VARCHAR(20) not null,
AUTH_CODE VARCHAR(8) ,
FUNAME_CN VARCHAR(20) not null,
FAXNUM VARCHAR(15),
INQ_CLAIM VARCHAR(4000) ,
SALE_CLAIM VARCHAR(4000),
SUR_CLAIM VARCHAR(4000) ,
CDATE DATE not null,
UDATE DATE not null,
QUOTE_CLAIM VARCHAR(4000),
constraint SQL080505021258750 primary key (USERNBR)
);
alter table bspdb.BSP_USER
add constraint FK123
foreign key (CORP_ID)
references bspdb.BSP_CORP(CORP_ID);