/* ================================================================================ 档案代号:apswsm 档案名称:APS 工作站 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apswsm ( ws_id varchar2(32) NOT NULL, /*工作中心编号 */ location varchar2(32), /*库房位置 */ ws_name varchar2(32), /*工作中心名称 */ ws_des varchar2(32) /*工作中心描述 */ ); create unique index apswsm_pk on apswsm (ws_id); alter table apswsm add constraint apswsm_pk primary key (ws_id) enable validate; grant select on apswsm to public; grant index on apswsm to public; grant update on apswsm to public; grant delete on apswsm to public; grant insert on apswsm to public; |