oracle 标准建表语句

最新推荐文章于 2024-07-18 09:45:00 发布

Carl_YC

最新推荐文章于 2024-07-18 09:45:00 发布

阅读量4.3k

点赞数

分类专栏：数据库文章标签： oracle constraints system table image date

本文链接：https://blog.csdn.net/wayfoon322/article/details/2306976

版权

数据库专栏收录该内容

11 篇文章 0 订阅

订阅专栏

oracle 标准建表语句

create table TABLENAME
(
STOCKID       NUMBER not null,
USERID        NUMBER,
MODEL         VARCHAR2(100),
MAKER         VARCHAR2(100),
AMOUNT        NUMBER default 0,
LOTNUMBER     VARCHAR2(100),
UPTRANSDATE   DATE default SYSDATE,
PRICE         NUMBER(8,2) default 0,
STATE         NUMBER default 0,
ENCAPSULATION VARCHAR2(50),
DESCRIBE      VARCHAR2(1000),
VOUCH         NUMBER default 1,
SPOTGOODS     NUMBER default 0
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
    initial 16
    minextents 1
    maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table TABLENAME
add constraint PK_SYSICSTOCK primary key (STOCKID)
using index
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
    initial 16K
    minextents 1
    maxextents unlimited
);
alter table TABLENAME
add constraint FK_SYSICSTO_IC foreign key (USERID)
references SYSMEMBER (USERID);
-- Create/Recreate indexes
create index INDEX_MODEL on TABLENAME (MODEL)
tablespace SYSTEM
pctfree 10
initrans 2
maxtrans 255
storage
(
    initial 64K
    minextents 1
    maxextents unlimited
);