摘要：-- Create tablecreate table RBAC_GRANT( GRANT_ID INTEGER not null, PERMISSION_ID INTEGER, ROLE_ID INTEGER, ACTION VARCHAR2(500))-- Add comments to the columns comment on column RBAC_GRANT.GRANT_ID is '编号';comment on column RBAC_GRANT.PERMISSION_ID is '权限编号';comment on column ... 阅读全文

摘要：-- Create tablecreate table QQ_SERVICE( ID INTEGER not null, NAME VARCHAR2(30 CHAR), QQ VARCHAR2(20 CHAR), CREATE_TIME DATE default SYSDATE, UPDATE_TIME DATE null, TYPE_ID INTEGER not null)-- Add comments to the table comment on table QQ_SERVICE is 'QQ客服表';-- Add ... 阅读全文

摘要：-- Create tablecreate table DISTRICT_CODE( DISTRICT_ID INTEGER PRIMARY KEY NOT NULL, NAME VARCHAR2(30 CHAR) not null, PARENT_DISTRICT_ID INTEGER default 0 not null, PROVINCE_ID INTEGER default 0 not null, PROVINCE_NAME VARCHAR2(30 CHAR), CITY_ID I... 阅读全文

摘要：-- Create tablecreate table COMMON_TYPE( TYPE_ID INTEGER PRIMARY KEY NOT NULL, TYPE_CODE VARCHAR2(40) not null, TYPE_NAME VARCHAR2(40 CHAR) not null, NAME VARCHAR2(40 CHAR), PARENT_ID INTEGER default 0 not null, DESCRIPTION VARCHAR2(100 CHAR), GRADE INTEGER defa... 阅读全文