21 lines
993 B
SQL
21 lines
993 B
SQL
CREATE TABLE CAPLICDATA (
|
|
CRE_DT VARCHAR2(8) DEFAULT '',
|
|
CRE_TM VARCHAR2(6) DEFAULT '',
|
|
CAP_TYP VARCHAR2(50) NOT NULL,
|
|
LIC_NAME VARCHAR2(50) NOT NULL,
|
|
LIC_DESC VARCHAR2(512) DEFAULT '',
|
|
IS_USED VARCHAR2(2) DEFAULT 'N',
|
|
REMACK VARCHAR2(128) DEFAULT '',
|
|
TM_SMP VARCHAR2(26) DEFAULT ''
|
|
);
|
|
ALTER TABLE CAPLICDATA ADD CONSTRAINT CAPLICDATA_PK PRIMARY KEY (CAP_TYP,LIC_NAME) USING INDEX;
|
|
COMMENT ON TABLE CAPLICDATA IS '应用场景基本信息表';
|
|
COMMENT ON COLUMN CAPLICDATA.CRE_DT IS '创建日期';
|
|
COMMENT ON COLUMN CAPLICDATA.CRE_TM IS '创建时间';
|
|
COMMENT ON COLUMN CAPLICDATA.CAP_TYP IS '业务类型';
|
|
COMMENT ON COLUMN CAPLICDATA.LIC_NAME IS '场景名称';
|
|
COMMENT ON COLUMN CAPLICDATA.LIC_DESC IS '场景说明';
|
|
COMMENT ON COLUMN CAPLICDATA.IS_USED IS '是否生效 Y 生效 N 无效';
|
|
COMMENT ON COLUMN CAPLICDATA.REMACK IS '备用字段';
|
|
COMMENT ON COLUMN CAPLICDATA.TM_SMP IS '时间戳';
|