- 论坛徽章:
- 0
|
主键是没有问题的,
-- Create table
create table XSJL
(
SKTNO VARCHAR2(6) not null,
JLBH NUMBER(10) not null,
JYSJ DATE not null,
JZRQ DATE not null,
SKY NUMBER(10) not null,
THFHR NUMBER(10),
VIPTYPE NUMBER(5),
VIPID NUMBER(10),
XSJE NUMBER(16,2) default 0 not null,
SFJE NUMBER(16,2),
OLD_JLBH NUMBER(10),
OLD_SKTNO VARCHAR2(6)
)
tablespace BFJXC
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table XSJL
add constraint PK_XSJL primary key (SKTNO, JLBH) |
|