小型点在商务项目

create table APPOINT ( id INTEGER not null, wineshopid INTEGER, feastid INTEGER, orderuserid VARCHAR2(20), orderusername VARCHAR2(32), orderusertel VARCHAR2(20), adminworkno VARCHAR2(64), orderrequire CLOB, orderstatus INTEGER, weddingtdate DATE, userid VARCHAR2(20), wineshopname VARCHAR2(64), feastname VARCHAR2(64) ) ; comment on column APPOINT.orderstatus is '1-新预约 2-处理中 3-已完成 4-已关闭'; alter table APPOINT add constraint PK_APPOINT primary key (ID);