零部件表设计 T_AIS_BASE_PARTS_INFO
零部件表
create table T_AIS_BASE_PARTS_INFO
(
PART_ID VARCHAR2(15) not null,
PART_CODE VARCHAR2(50) not null,
PART_NAME VARCHAR2(100) not null,
PART_STATUS VARCHAR2(10),
AREA_CODE VARCHAR2(10),
CUSTOMER_ID VARCHAR2(10) not null,
CUSTOMER_NAME VARCHAR2(500),
PRODUCT_CODE VARCHAR2(10),
PRODUCT_NAME VARCHAR2(150),
VARIETY_CODE VARCHAR2(10),
VARIETY_NAME VARCHAR2(50),
SHOPSIGN VARCHAR2(10),
MATERIAL_NUMBER VARCHAR2(15),
MATERIAL_NAME VARCHAR2(50),
MATERIAL_THICK NUMBER(10,3),
MATERIAL_WIDTH NUMBER(10,3),
MATERIAL_LENGTH NUMBER(10,3),
FINISHED_MATERIALS_NUMBER VARCHAR2(15),
FINISHED_MATERIALS_NAME VARCHAR2(100),
CUT_SIZE_THICK NUMBER(10,3),
CUT_SIZE_WIDTH NUMBER(10,3),
CUT_SIZE_LENGTH NUMBER(10,3),
PART_COST_WEIGHT NUMBER(10,6),
ZINC_COATING VARCHAR2(15),
STEEL_PLATE_SURFACE_DISPOSE VARCHAR2(15),
PARTS_POST_DISPOSE VARCHAR2(15),
STAMPING_LEVEL VARCHAR2(15),
APN VARCHAR2(15),
PSR VARCHAR2(15),
ORDER_STANDARD VARCHAR2(15),
LIEFERANT VARCHAR2(15),
CUT_FACTORY VARCHAR2(15),
MATERIAL_YIELD VARCHAR2(15),
REMARK VARCHAR2(200),
CREATE_ID VARCHAR2(10),
CREATE_DATE DATE,
UPDATE_ID VARCHAR2(10),
UPDATE_DATE DATE,
STATUS VARCHAR2(10),
PRODUCT_ADDRESS VARCHAR2(100),
DENSITY NUMBER(10,3),
BUSINES_DEPARTMENT VARCHAR2(50),
UNIT_CODE VARCHAR2(10)
)
tablespace AIS_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the columns
comment on column T_AIS_BASE_PARTS_INFO.PART_ID
is '零件代码';
comment on column T_AIS_BASE_PARTS_INFO.PART_CODE
is '客户方零件号';
comment on column T_AIS_BASE_PARTS_INFO.PART_NAME
is '零件名称';
comment on column T_AIS_BASE_PARTS_INFO.PART_STATUS
is '零件状态(10,有效;00,无效)';
comment on column T_AIS_BASE_PARTS_INFO.AREA_CODE
is '区域(值集码为AREA_CODE)';
comment on column T_AIS_BASE_PARTS_INFO.CUSTOMER_ID
is '客户代码';
comment on column T_AIS_BASE_PARTS_INFO.CUSTOMER_NAME
is '客户名称';
comment on column T_AIS_BASE_PARTS_INFO.PRODUCT_CODE
is '产品代码[关联产品信息表取得产品型号]';
comment on column T_AIS_BASE_PARTS_INFO.PRODUCT_NAME
is '产品名称';
comment on column T_AIS_BASE_PARTS_INFO.VARIETY_CODE
is '品种代码';
comment on column T_AIS_BASE_PARTS_INFO.VARIETY_NAME
is '品种名称';
comment on column T_AIS_BASE_PARTS_INFO.SHOPSIGN
is '牌号';
comment on column T_AIS_BASE_PARTS_INFO.MATERIAL_NUMBER
is '原料物料号';
comment on column T_AIS_BASE_PARTS_INFO.MATERIAL_NAME
is '原料名称';
comment on column T_AIS_BASE_PARTS_INFO.MATERIAL_THICK
is '原料厚度';
comment on column T_AIS_BASE_PARTS_INFO.MATERIAL_WIDTH
is '原料宽度';
comment on column T_AIS_BASE_PARTS_INFO.MATERIAL_LENGTH
is '原料长度';
comment on column T_AIS_BASE_PARTS_INFO.FINISHED_MATERIALS_NUMBER
is '成品物料号';
comment on column T_AIS_BASE_PARTS_INFO.FINISHED_MATERIALS_NAME
is '成品物料名称';
comment on column T_AIS_BASE_PARTS_INFO.CUT_SIZE_THICK
is '剪切厚度';
comment on column T_AIS_BASE_PARTS_INFO.CUT_SIZE_WIDTH
is '剪切宽度';
comment on column T_AIS_BASE_PARTS_INFO.CUT_SIZE_LENGTH
is '剪切长度';
comment on column T_AIS_BASE_PARTS_INFO.PART_COST_WEIGHT
is '单耗(KG)';
comment on column T_AIS_BASE_PARTS_INFO.ZINC_COATING
is '锌层';
comment on column T_AIS_BASE_PARTS_INFO.STEEL_PLATE_SURFACE_DISPOSE
is '钢板表面处理';
comment on column T_AIS_BASE_PARTS_INFO.PARTS_POST_DISPOSE
is '零部件后处理';
comment on column T_AIS_BASE_PARTS_INFO.STAMPING_LEVEL
is '冲压等级';
comment on column T_AIS_BASE_PARTS_INFO.APN
is 'APN';
comment on column T_AIS_BASE_PARTS_INFO.PSR
is 'PSR';
comment on column T_AIS_BASE_PARTS_INFO.ORDER_STANDARD
is '订货标准';
comment on column T_AIS_BASE_PARTS_INFO.LIEFERANT
is '配套厂';
comment on column T_AIS_BASE_PARTS_INFO.CUT_FACTORY
is '剪切厂';
comment on column T_AIS_BASE_PARTS_INFO.MATERIAL_YIELD
is '成材率';
comment on column T_AIS_BASE_PARTS_INFO.REMARK
is '备注';
comment on column T_AIS_BASE_PARTS_INFO.CREATE_ID
is '创建人';
comment on column T_AIS_BASE_PARTS_INFO.CREATE_DATE
is '创建日期';
comment on column T_AIS_BASE_PARTS_INFO.UPDATE_ID
is '更新人';
comment on column T_AIS_BASE_PARTS_INFO.UPDATE_DATE
is '更新日期';
comment on column T_AIS_BASE_PARTS_INFO.STATUS
is '有效状态[10，有效，00。无效]';
comment on column T_AIS_BASE_PARTS_INFO.PRODUCT_ADDRESS
is '产地';
comment on column T_AIS_BASE_PARTS_INFO.DENSITY
is '密度';
comment on column T_AIS_BASE_PARTS_INFO.BUSINES_DEPARTMENT
is '事业部';
comment on column T_AIS_BASE_PARTS_INFO.UNIT_CODE
is '单位代码';
Powered by Zoundry
