企业规模代码表

prompt PL/SQL Developer import file

prompt Created on 2012年3月31日 by syan

set feedback off

set define off

prompt Creating T_DM_GY_QYGM...

create table T_DM_GY_QYGM

(

QYGM_DM CHAR(1) not null,

MC VARCHAR2(40),

MC_J VARCHAR2(40),

TJQYGM_DM CHAR(2),

XY_BJ CHAR(1),

LR_SJ TIMESTAMP(6),

XG_SJ TIMESTAMP(6)

)

tablespace TS_JAXT

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

next 1M

minextents 1

maxextents unlimited

);

comment on table T_DM_GY_QYGM

is '企业规模代码表';

comment on column T_DM_GY_QYGM.QYGM_DM

is '企业规模代码';

comment on column T_DM_GY_QYGM.MC

is '名称';

comment on column T_DM_GY_QYGM.MC_J

is '简称';

comment on column T_DM_GY_QYGM.TJQYGM_DM

is '统计用规模代码';

comment on column T_DM_GY_QYGM.XY_BJ

is '选用标志';

comment on column T_DM_GY_QYGM.LR_SJ

is '录入时间';

comment on column T_DM_GY_QYGM.XG_SJ

is '修改时间';

alter table T_DM_GY_QYGM

add constraint PK_T_DM_GY_QYGM primary key (QYGM_DM)

第1页下一页