40 lines
791 B
Plaintext
40 lines
791 B
Plaintext
-- Create table
|
|
create table RES_CUSTOMER_BEST
|
|
(
|
|
resid VARCHAR2(100) not null,
|
|
ctime DATE,
|
|
utime DATE,
|
|
createid NUMBER,
|
|
cuserName VARCHAR2(255) not null,
|
|
corpid VARCHAR2(255) not null,
|
|
outuserid VARCHAR2(255) not null,
|
|
userid VARCHAR2(255) not null,
|
|
remark VARCHAR2(1000)
|
|
)
|
|
tablespace UPDEV_DATA
|
|
pctfree 10
|
|
initrans 1
|
|
maxtrans 255
|
|
storage
|
|
(
|
|
initial 64K
|
|
next 1M
|
|
minextents 1
|
|
maxextents unlimited
|
|
);
|
|
-- Create/Recreate primary, unique and foreign key constraints
|
|
alter table RES_CUSTOMER_BEST
|
|
add constraint PK_RES_CUSTOMER_BEST_RESID primary key (RESID)
|
|
using index
|
|
tablespace UPDEV_DATA
|
|
pctfree 10
|
|
initrans 2
|
|
maxtrans 255
|
|
storage
|
|
(
|
|
initial 64K
|
|
next 1M
|
|
minextents 1
|
|
maxextents unlimited
|
|
);
|