配送计划导入主表设计

create table T_AIS_CL_OUTPUT_M
(
GROUP_ID VARCHAR2(20),
PLAN_MGR_ID VARCHAR2(20) not null,
CUSTOMER_ID VARCHAR2(20),
CUSTOMER_NAME VARCHAR2(50),
PRODUCT_TYPE_CODE VARCHAR2(10),
PRODUCT_TYPE_NAME VARCHAR2(50),
PRODUCT_MODEL_CODE VARCHAR2(50),
PRODUCT_MODEL VARCHAR2(50),
MANAGE_DIMENSIONALITY VARCHAR2(10),
OUTPUT_TYPE VARCHAR2(10),
PRODUCING_AREA VARCHAR2(50),
STATUS VARCHAR2(10) default 10,
REMARK VARCHAR2(200),
CREATE_ID VARCHAR2(10),
CREATE_DATE DATE default sysdate,
UPDATE_ID VARCHAR2(10),
UPDATE_DATE DATE,
MATERIEL_CODE VARCHAR2(20),
MATERIEL_NAME VARCHAR2(200),
FACTORY VARCHAR2(10),
DIVISION VARCHAR2(10)
)
tablespace AIS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table T_AIS_CL_OUTPUT_M
is '家电产量主信息';
-- Add comments to the columns
comment on column T_AIS_CL_OUTPUT_M.GROUP_ID
is '小组';
comment on column T_AIS_CL_OUTPUT_M.PLAN_MGR_ID
is '计划管理号';
comment on column T_AIS_CL_OUTPUT_M.CUSTOMER_ID
is '客户编码';
comment on column T_AIS_CL_OUTPUT_M.CUSTOMER_NAME
is '客户名称';
comment on column T_AIS_CL_OUTPUT_M.PRODUCT_TYPE_CODE
is '产品类型代码';
comment on column T_AIS_CL_OUTPUT_M.PRODUCT_TYPE_NAME
is '产品类型名称';
comment on column T_AIS_CL_OUTPUT_M.PRODUCT_MODEL_CODE
is '产品型号代码－取消';
comment on column T_AIS_CL_OUTPUT_M.PRODUCT_MODEL
is '产品型号名称－取消';
comment on column T_AIS_CL_OUTPUT_M.MANAGE_DIMENSIONALITY
is '管理维度[10 年
20 季
30月 40
周 50
日
]－取消';
comment on column T_AIS_CL_OUTPUT_M.OUTPUT_TYPE
is '产量类型[10 计划，20 实际]';
comment on column T_AIS_CL_OUTPUT_M.PRODUCING_AREA
is '产地';
comment on column T_AIS_CL_OUTPUT_M.STATUS
is '有效状态[10，有效，00。无效]';
comment on column T_AIS_CL_OUTPUT_M.REMARK
is '备注';
comment on column T_AIS_CL_OUTPUT_M.CREATE_ID
is '创建人';
comment on column T_AIS_CL_OUTPUT_M.CREATE_DATE
is '创建日期';
comment on column T_AIS_CL_OUTPUT_M.UPDATE_ID
is '更新人';
comment on column T_AIS_CL_OUTPUT_M.UPDATE_DATE
is '更新日期';
comment on column T_AIS_CL_OUTPUT_M.MATERIEL_CODE
is '子件物料号';
comment on column T_AIS_CL_OUTPUT_M.MATERIEL_NAME
is '子件物料描述';
comment on column T_AIS_CL_OUTPUT_M.FACTORY
is '工厂';
comment on column T_AIS_CL_OUTPUT_M.DIVISION
is '事业部';
-- Create/Recreate primary, unique and foreign key constraints
alter table T_AIS_CL_OUTPUT_M
add constraint PK_T_AIS_CL_OUTPUT_M_ID primary key (PLAN_MGR_ID)
using index
tablespace AIS_DATA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);

Powered by Zoundry