Design of importing a distribution plan to a master table

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 64 K
Minextents 1
Maxextents Unlimited
);
-- Add comments to the table
Comment on table t_ais_cl_output_m
Is 'main household appliance output information ';
-- Add comments to the columns
Comment on column t_ais_cl_output_m.group_id
Is 'group ';
Comment on column t_ais_cl_output_m.plan_mgr_id
Is 'scheduler management number ';
Comment on column t_ais_cl_output_m.mermer_id
Is 'customer Code ';
Comment on column t_ais_cl_output_m.customer_name
Is 'customer name ';
Comment on column t_ais_cl_output_m.product_type_code
Is 'product type Code ';
Comment on column t_ais_cl_output_m.product_type_name
Is 'product type name ';
Comment on column t_ais_cl_output_m.product_model_code
Is 'product Model Code-cancel ';
Comment on column t_ais_cl_output_m.product_model
Is 'product model name-cancel ';
Comment on column t_ais_cl_output_m.manage_dimensionality
Is 'management dimension [10 years
Quarter 20
30-month 40
Week 50
Day
]-Cancel ';
Comment on column t_ais_cl_output_m.output_type
Is 'yield type [10 plan, 20 actual] ';
Comment on column t_ais_cl_output_m.producing_area
Is 'origin ';
Comment on column t_ais_cl_output_m.status
Is 'valid status [10, valid, 00. Invalid] ';
Comment on column t_ais_cl_output_m.remark
Is 'note ';
Comment on column t_ais_cl_output_m.create_id
Is 'creator ';
Comment on column t_ais_cl_output_m.create_date
Is 'creation date ';
Comment on column t_ais_cl_output_m.update_id
Is 'updater ';
Comment on column t_ais_cl_output_m.update_date
Is 'Update date ';
Comment on column t_ais_cl_output_m.materiel_code
Is 'child item No ';
Comment on column t_ais_cl_output_m.materiel_name
Is 'item description ';
Comment on column t_ais_cl_output_m.factory
Is 'factory ';
Comment on column t_ais_cl_output_m.division
Is 'business ';
-- 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 64 K
Minextents 1
Maxextents Unlimited
);

Powered by zoundry