sql.txt

客户

建表
create table S_CUSTOMER
(
  C_ID        NUMBER  not null,
  C_NAME  VARCHAR2(40) not null,
  C_CATE  VARCHAR2(60) ,
  C_TRADE     VARCHAR2(60),
  C_GRADE     VARCHAR2(10),
  M_STATE      VARCHAR2(10)
 
)
;
alter table S_CUSTOMER add constraint S_CUSTOMER_PK primary key (C_ID);