Oracle标准建表语句

--CREATE TABLE 建表
CREATE TABLE OUTLN.CUSTOMER(
ID VARCHAR2(32) DEFAULT SYS_GUID() NOT NULL,
CUST_ID VARCHAR2(64),
CUST_NAME VARCHAR2(255),
ID_NO  VARCHAR2(64),
MOBILE VARCHAR2(16),
CREATED_BY  VARCHAR2(100) DEFAULT 'SYS',
DATE_CREATED  DATE DEFAULT SYSDATE,
UPDATED_BY  VARCHAR2(100) DEFAULT 'SYS',
DATE_UPDATED  DATE DEFAULT SYSDATE
)MONITORING,INITRANS 6;


-- ADD COMMENTS TO THE TABLE 添加注释
COMMENT ON TABLE OUTLN.CUSTOMER  IS '客户信息表';
-- ADD COMMENTS TO THE COLUMNS
COMMENT ON COLUMN OUTLN.CUSTOMER.ID IS '主键ID';
COMMENT ON COLUMN OUTLN.CUSTOMER.CUST_ID IS '系统名单唯一标示';
COMMENT ON COLUMN OUTLN.CUSTOMER.CUST_NAME  IS '客户姓名';
COMMENT ON COLUMN OUTLN.CUSTOMER.ID_NO  IS '身份证号';
COMMENT ON COLUMN OUTLN.CUSTOMER.MOBILE  IS '客户手机号';
COMMENT ON COLUMN OUTLN.CUSTOMER.CREATED_BY  IS '创建人';
COMMENT ON COLUMN OUTLN.CUSTOMER.DATE_CREATED  IS '创建时间';
COMMENT ON COLUMN OUTLN.CUSTOMER.UPDATED_BY   IS '更新人';
COMMENT ON COLUMN OUTLN.CUSTOMER.DATE_UPDATED  IS '更新时间';



-- CREATE/RECREATE INDEXES 建立索引
CREATE INDEX OUTLN.IDX_CUSTOMER_MOBILE ON OUTLN.CUSTOMER (MOBILE) INITRANS 16;

-- CREATE/RECREATE PRIMARY INDEX 建立唯一索引
CREATE UNIQUE INDEX OUTLN.IDX_CUSTOMER_CUSTOMER_ID_NO ON OUTLN.CUSTOMER (ID_NO) INITRANS 16;

-- CREATE/RECREATE PRIMARY CONSTRAINTS 建立主键
ALTER TABLE OUTLN.CUSTOMER ADD CONSTRAINT PK_CUSTOMER_CUSTOMER PRIMARY KEY (ID) USING INDEX OUTLN.IDX_CUSTOMER_CUSTOMER;


-- CREATE SYNONYM 建立同义词
CREATE PUBLIC SYNONYM CUSTOMER FOR OUTLN.CUSTOMER;