erp

Production Table List

By ukmodak | April 1st 2024 12:11:14 PM | viewed 228 times





create table prod_opunit(
id number(20) not null,
stn_hrm_company_id number(20) not null,
stn_item_group_id number(20) not null,
stn_item_unit_id number(20) not null, 
operating_unit_name varchar2(50) not null,
alias varchar2(50) not null,
code varchar2(50) not null,
description varchar2(150) not null,   
CONSTRAINT stn_hrm_company_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_item_group_fk FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT stn_item_unit_fk FOREIGH KEY(stn_item_unit_id) REFERENCES stn_item_unit_id,
CONSTRAINT prod_opunit_pk PRIMARY KEY(id)
)
create table prod_opunit_incharge(
id number(20) not null,
prod_opunit_id number(20) not null,
auth_user_id number(20) not null,   
CONSTRAINT operating_unit_id_fk FOREIGH KEY(operating_unit_id) REFERENCES prod_opunit,
CONSTRAINT auth_user_id_fk FOREIGH KEY(auth_user_id) REFERENCES auth_user,
CONSTRAINT prod_opunit_incharge_pk PRIMARY KEY(id)
)
create table prod_tools(
id number(20) not null,
stn_hrm_company_id number(20) not null,
prod_opunit_id number(20) not null,
tools_type_lookup_dtl_id  number(20) not null, -- machine,computer,iron,manpower...
tools_name varchar2(50) not null, 
tools_no_code varchar2(50) not null, 
tools_specific varchar2(150) default null, 
prod_capacity_per_hr number(5) not null, 
stn_munit_id number(20) not null,  
 
CONSTRAINT stn_hrm_company_id_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT prod_opunit_fk FOREIGH KEY(prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT stn_munit_id_fk FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT tools_type_lookup_dtl_fk FOREIGH KEY(tools_type_lookup_dtl_id) REFERENCES lookup_dtl,
CONSTRAINT prod_tools_pk PRIMARY KEY(id)
)
create table prod_tools_user(
id number(20) not null,
prod_tools_id number(20) not null,
auth_user_id number(20) not null,    
CONSTRAINT prod_tools_fk FOREIGH KEY(prod_tools_id) REFERENCES prod_tools,
CONSTRAINT auth_user_id_fk FOREIGH KEY(auth_user_id) REFERENCES auth_user,
CONSTRAINT prod_tools_user_pk PRIMARY KEY(id)
)
create table prod_item_rcp_setup_mst(
id number(20) not null,
recipe_name varchar2(70) not null,
detail_info varchar2(200) default null,
stn_hrm_company_id number(20) not null,
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,  --[from sample table]


CONSTRAINT stn_hrm_company_fk1 FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,

CONSTRAINT prod_item_rcp_setup_mst_pk PRIMARY KEY(id)
)
create table prod_item_rcp_setup_attr(
id number(20) not null,
prod_item_rcp_setup_mst_id number(20) not null,
smp_sample_attribute_type_id number(20) not null,
smp_sample_attribute_val_id number(20) not null,

leign varchar2(50) not null,
color_id number(20) not null,
blank_thickness number(4,2) not null,
blank_thickness_stn_munit_id number(20) not null,
finish_thickness number(4,2) not null,
finish_thickness_stn_munit_id number(20) not null,
sheet_rod varchar2(50) not null,
req_qty number(4,2) not null,
stn_munit_id number(20) not null,
moq_qty number(4,2) not null,
total_rm number(4,2) not null,
total_rm_stn_munit_cnvt_dtl_id number(4,2) not null,
total_percent number(4,2) not null,


CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT smp_sample_attribute_type_fk1 FOREIGH KEY(smp_sample_attribute_type_id) REFERENCES smp_sample_attribute_type,
CONSTRAINT smp_sample_attribute_val_fk1 FOREIGH KEY(smp_sample_attribute_val_id) REFERENCES smp_sample_attribute_val,

CONSTRAINT stn_color_fk1 FOREIGH KEY(stn_color_id) REFERENCES stn_color,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT blank_thickness_stn_munit_fk1 FOREIGH KEY(blank_thickness_stn_munit_id) REFERENCES stn_munit,
CONSTRAINT finish_thickness_stn_munit_fk1 FOREIGH KEY(finish_thickness_stn_munit_id) REFERENCES stn_munit,
CONSTRAINT total_rm_stn_munit_cnvtdtl_fk1 FOREIGH KEY(total_rm_stn_munit_cnvt_dtl_id) REFERENCES stn_munit_converter_dtl,

CONSTRAINT prod_item_rcp_setup_attr_pk PRIMARY KEY(id)
)
create table prod_item_rcp_setup_rm(
id number(20) not null,
prod_item_rcp_setup_mst_id number(20) not null,
prod_item_rcp_setup_attr_id number(20) not null,
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,   --[from sample module]

stn_munit_id number(20) not null,
percent number(4,2) not null,
qty number(4,2) not null,
stn_munit_cnvt_dtl_id number(4,2) not null,

CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl,
CONSTRAINT prod_item_rcp_setup_rm_pk PRIMARY KEY(id)
)
create table prod_prdtn_process_mst(
id number(20) not null,
production_name varchar2(50) not null,
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,
stn_hrm_company_id number(20) not null,
smp_sample_id number(20) default null,
ord_order_id number(20) default null,
 
CONSTRAINT stn_item_group_fk FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_hrm_company_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company,
CONSTRAINT smp_sample_fk FOREIGH KEY(smp_sample_id) REFERENCES smp_sample,
CONSTRAINT ord_order_fk FOREIGH KEY(ord_order_id) REFERENCES ord_order,

CONSTRAINT prod_prdtn_process_mst_pk PRIMARY KEY(id)
)
create table prod_prdtn_process_dtl(
id number(20) not null,
prod_prdtn_process_mst_id number(20) not null,
unit_sts_lookup_dtl_id number(20) not null,
current_prod_opunit_id number(20) not null, 
next_prod_opunit_id number(20) not null,
step_no number(4) not null,
is_active number(1) not null,
work_sts_lookup_dtl_id number(20) not null,  -- work in progress,done
inspect_sts_lookup_dtl_id  number(20) default null,  -- inspected,reinspect,rejected
  
CONSTRAINT prod_prdtn_process_mst_fk FOREIGH KEY(prod_prdtn_process_mst_id) REFERENCES prod_prdtn_process_mst,
CONSTRAINT unit_sts_lookup_dtl_fk FOREIGH KEY(unit_sts_lookup_dtl_id) REFERENCES unit_sts_lookup_dtl,
CONSTRAINT current_prod_opunit_fk FOREIGH KEY(current_prod_opunit_id) REFERENCES current_prod_opunit,
CONSTRAINT next_prod_opunit_fk FOREIGH KEY(next_prod_opunit_id) REFERENCES next_prod_opunit,
CONSTRAINT prod_prdtn_process_dtl_pk PRIMARY KEY(id)
)
create table prod_rcp_brkdown_batch(
id number(20) not null,
prod_prdtn_process_dtl_id
smp_sample_breakdown_id default null,
ord_order_breakdown_id default null,

CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl,
CONSTRAINT smp_sample_breakdown_fk FOREIGH KEY(smp_sample_breakdown_id) REFERENCES smp_sample_breakdown,
CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_rcp_brkdown_batch_pk PRIMARY KEY(id)
)
create table prod_item_rcp_setup_attr(
id number(20) not null,
prod_item_rcp_setup_mst_id number(20) not null,
smp_sample_attribute_type_id number(20) not null,
smp_sample_attribute_val_id number(20) not null,

leign varchar2(50) not null,
color_id number(20) not null,
blank_thickness number(4,2) not null,
blank_thickness_stn_munit_id number(20) not null,
finish_thickness number(4,2) not null,
finish_thickness_stn_munit_id number(20) not null,
sheet_rod varchar2(50) not null,
req_qty number(4,2) not null,
stn_munit_id number(20) not null,
moq_qty number(4,2) not null,
total_rm number(4,2) not null,
total_rm_stn_munit_cnvt_dtl_id number(4,2) not null,
total_percent number(4,2) not null,


CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT smp_sample_attribute_type_fk1 FOREIGH KEY(smp_sample_attribute_type_id) REFERENCES smp_sample_attribute_type,
CONSTRAINT smp_sample_attribute_val_fk1 FOREIGH KEY(smp_sample_attribute_val_id) REFERENCES smp_sample_attribute_val,

CONSTRAINT stn_color_fk1 FOREIGH KEY(stn_color_id) REFERENCES stn_color,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT blank_thickness_stn_munit_fk1 FOREIGH KEY(blank_thickness_stn_munit_id) REFERENCES stn_munit,
CONSTRAINT finish_thickness_stn_munit_fk1 FOREIGH KEY(finish_thickness_stn_munit_id) REFERENCES stn_munit,
CONSTRAINT total_rm_stn_munit_cnvtdtl_fk1 FOREIGH KEY(total_rm_stn_munit_cnvt_dtl_id) REFERENCES stn_munit_converter_dtl,

CONSTRAINT prod_rcp_brkdown_batch_attr_pk PRIMARY KEY(id)
)
create table prod_rcp_brkdown_batch_rm(
id number(20) not null,
prod_rcp_brkdown_batch_id number(20) not null,


prod_item_rcp_setup_mst_id number(20) not null,       --[ from prod_item_rcp_setup_mst]
prod_rcp_brkdown_batch_attr_id number(20) not null,   --[ update tale of prod_item_rcp_setup_attr]
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,                --[from sample module]

stn_munit_id number(20) not null,
percent number(4,2) not null,
qty number(4,2) not null,
stn_munit_cnvt_dtl_id number(4,2) not null,

cur_prod_opunit_id number(20) not null,
next_prod_opunit_id number(20) default null,
sumit_date datetime default null,
is_lock numer(2) not null,


CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl,

CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit,

CONSTRAINT prod_rcp_brkdown_batch_rm_pk PRIMARY KEY(id)
)
create table prod_rqsn_brkdown_batch_rm(
id number(20) not null,
prod_rcp_brkdown_batch_id number(20) not null,


prod_item_rcp_setup_mst_id number(20) not null,       --[ from prod_item_rcp_setup_mst]
prod_rcp_brkdown_batch_attr_id number(20) not null,   --[ update tale of prod_item_rcp_setup_attr]
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,                --[from sample module]

stn_munit_id number(20) not null,
percent number(4,2) not null,
qty number(4,2) not null,
stn_munit_cnvt_dtl_id number(4,2) not null,
inv_warehouse_id number(20) default null,
inv_store_id number(20) default null,

cur_prod_opunit_id number(20) not null,
next_prod_opunit_id number(20) default null,
sumit_date datetime default null,
is_lock numer(2) not null,


CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl,

CONSTRAINT inv_warehouse_fk1 FOREIGH KEY(inv_warehouse_id) REFERENCES inv_warehouse,
CONSTRAINT inv_store_fk1 FOREIGH KEY(inv_store_id) REFERENCES inv_store,

CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit,

CONSTRAINT prod_rqsn_brkdown_batch_rm_pk PRIMARY KEY(id)
)
create table prod_recv_brkdown_batch_rm(
id number(20) not null,
prod_rcp_brkdown_batch_id number(20) not null,


prod_item_rcp_setup_mst_id number(20) not null,       --[ from prod_item_rcp_setup_mst]
prod_rcp_brkdown_batch_attr_id number(20) not null,   --[ update tale of prod_item_rcp_setup_attr]
stn_item_group_id number(20) not null, 
smp_item_setup_id number(20) not null,                --[from sample module]

stn_munit_id number(20) not null,
percent number(4,2) not null,
qty number(4,2) not null,
stn_munit_cnvt_dtl_id number(4,2) not null,
inv_warehouse_id number(20) default null,
inv_store_id number(20) default null,


cur_prod_opunit_id number(20) not null,
next_prod_opunit_id number(20) default null,
sumit_date datetime default null,
is_lock numer(2) not null,


CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst,
CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr,
CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group,
CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup,
CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit,
CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl,

CONSTRAINT inv_warehouse_fk1 FOREIGH KEY(inv_warehouse_id) REFERENCES inv_warehouse,
CONSTRAINT inv_store_fk1 FOREIGH KEY(inv_store_id) REFERENCES inv_store,

CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit,

CONSTRAINT prod_recv_brkdown_batch_rm_pk PRIMARY KEY(id)
)
create table prod_process_tools(
id number(20) not null,
prod_prdtn_process_dtl_id
prod_unit_id number(20) not null,
prod_tools_id number(20) not null,

cur_prod_opunit_id number(20) not null,
 
CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl,
CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit,
CONSTRAINT prod_tools_fk FOREIGH KEY(prod_tools_id) REFERENCES prod_tools,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_tools_pk PRIMARY KEY(id)
)
create table prod_process_tools_output(
id number(20) not null,
prod_process_tools_id number(20) not null,
start_time datetime default null,
end_time datetime default null,

cur_prod_opunit_id number(20) not null,

CONSTRAINT prod_process_tools_fk FOREIGH KEY(prod_process_tools_id) REFERENCES prod_process_tools,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_tools_output_pk PRIMARY KEY(id)
)
create table prod_process_tools_output(
id number(20) not null,
prod_process_tools_id number(20) not null,
date_time datetime not null,
output_name varchar2(50) not null,
output_qty number(4,2) not null,
wast_qty number(4,2) not null,

cur_prod_opunit_id number(20) not null,
next_prod_opunit_id number(20) default null,
sumit_date datetime default null,
is_lock numer(2) not null,
 
CONSTRAINT prod_process_tools_fk FOREIGH KEY(prod_process_tools_id) REFERENCES prod_process_tools,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_tools_output_pk PRIMARY KEY(id)
)
create table prod_process_asn_timeline(
id number(20) not null,
prod_prdtn_process_dtl_id number(20) not null,
prod_unit_id number(20) not null,

start_time datetime default null,
end_time datetime default null,
extend_time datetime default null,
actual_finish_time datetime default null,

cur_prod_opunit_id number(20) not null,

CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl,
CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_asn_timeline_pk PRIMARY KEY(id)
)
create table prod_process_asn_timeline(
id number(20) not null,
prod_prdtn_process_dtl_id number(20) not null,
prod_unit_id number(20) not null,
comment varchar2(50) default null,
cur_prod_opunit_id number(20) not null,

CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl,
CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit,
CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit,
CONSTRAINT prod_process_asn_comment_pk PRIMARY KEY(id)
)
create table prod_delivery_challan(
id number(20) not null,
prod_prdtn_process_mst_id number(20) not null,

delivery_man varchar2(50) default null,
driver varchar2(50) default null,
vehicle_no varchar2(50) default null,
delivery_note_date date default null,
delivery_note_type varchar2(50) default null,
delivery_note_received varchar2(50) default null,
bill_challan_no varchar2(50) default null,
bill_challan_date date default null,
is_bill_prepared number(2) not null,
remarks varchar2(100) default null,

inv_warehouse_id number(20) default null,
inv_store_id number(20) default null,

is_received number(2) default null,
received_date date default null,
received_by varchar2(50) default null,

CONSTRAINT prod_prdtn_process_mst_fk1 FOREIGH KEY(prod_prdtn_process_mst_id) REFERENCES prod_prdtn_process_mst,
CONSTRAINT prod_delivery_challan_pk PRIMARY KEY(id)
)
create table prod_challan_batch(
id number(20) not null,
prod_delivery_challan_id number(20) not null,
smp_sample_breakdown_id default null,
ord_order_breakdown_id default null,

CONSTRAINT prod_delivery_challan_fk1 FOREIGH KEY(prod_delivery_challan_id) REFERENCES prod_delivery_challan,
CONSTRAINT smp_sample_breakdown_fk1 FOREIGH KEY(smp_sample_breakdown_id) REFERENCES smp_sample_breakdown,
CONSTRAINT ord_order_breakdown_fk1 FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown,
CONSTRAINT prod_challan_batch_pk PRIMARY KEY(id)
)

Sl	Table Name:	Query	example record
1-26	Setup Table(From Setup Module)	----
1-38	Sample Module Table(From Sample Module)	----	get table by schema or api
1-48	Order Module Table(From Order Module)	----	get table by schema or api
1	prod_opunit	create table prod_opunit( id number(20) not null, stn_hrm_company_id number(20) not null, stn_item_group_id number(20) not null, stn_item_unit_id number(20) not null, operating_unit_name varchar2(50) not null, alias varchar2(50) not null, code varchar2(50) not null, description varchar2(150) not null, CONSTRAINT stn_hrm_company_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT stn_item_group_fk FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group, CONSTRAINT stn_item_unit_fk FOREIGH KEY(stn_item_unit_id) REFERENCES stn_item_unit_id, CONSTRAINT prod_opunit_pk PRIMARY KEY(id) )
2	prod_opunit_incharge	create table prod_opunit_incharge( id number(20) not null, prod_opunit_id number(20) not null, auth_user_id number(20) not null, CONSTRAINT operating_unit_id_fk FOREIGH KEY(operating_unit_id) REFERENCES prod_opunit, CONSTRAINT auth_user_id_fk FOREIGH KEY(auth_user_id) REFERENCES auth_user, CONSTRAINT prod_opunit_incharge_pk PRIMARY KEY(id) )
3	prod_tools	create table prod_tools( id number(20) not null, stn_hrm_company_id number(20) not null, prod_opunit_id number(20) not null, tools_type_lookup_dtl_id number(20) not null, -- machine,computer,iron,manpower... tools_name varchar2(50) not null, tools_no_code varchar2(50) not null, tools_specific varchar2(150) default null, prod_capacity_per_hr number(5) not null, stn_munit_id number(20) not null, CONSTRAINT stn_hrm_company_id_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT prod_opunit_fk FOREIGH KEY(prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT stn_munit_id_fk FOREIGH KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT tools_type_lookup_dtl_fk FOREIGH KEY(tools_type_lookup_dtl_id) REFERENCES lookup_dtl, CONSTRAINT prod_tools_pk PRIMARY KEY(id) )
4	prod_tools_user	create table prod_tools_user( id number(20) not null, prod_tools_id number(20) not null, auth_user_id number(20) not null, CONSTRAINT prod_tools_fk FOREIGH KEY(prod_tools_id) REFERENCES prod_tools, CONSTRAINT auth_user_id_fk FOREIGH KEY(auth_user_id) REFERENCES auth_user, CONSTRAINT prod_tools_user_pk PRIMARY KEY(id) )
5	prod_item_rcp_setup_mst(rcp = recipe)	create table prod_item_rcp_setup_mst( id number(20) not null, recipe_name varchar2(70) not null, detail_info varchar2(200) default null, stn_hrm_company_id number(20) not null, stn_item_group_id number(20) not null, smp_item_setup_id number(20) not null, --[from sample table] CONSTRAINT stn_hrm_company_fk1 FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group, CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT prod_item_rcp_setup_mst_pk PRIMARY KEY(id) )
6	prod_item_rcp_setup_attr	create table prod_item_rcp_setup_attr( id number(20) not null, prod_item_rcp_setup_mst_id number(20) not null, smp_sample_attribute_type_id number(20) not null, smp_sample_attribute_val_id number(20) not null, leign varchar2(50) not null, color_id number(20) not null, blank_thickness number(4,2) not null, blank_thickness_stn_munit_id number(20) not null, finish_thickness number(4,2) not null, finish_thickness_stn_munit_id number(20) not null, sheet_rod varchar2(50) not null, req_qty number(4,2) not null, stn_munit_id number(20) not null, moq_qty number(4,2) not null, total_rm number(4,2) not null, total_rm_stn_munit_cnvt_dtl_id number(4,2) not null, total_percent number(4,2) not null, CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst, CONSTRAINT smp_sample_attribute_type_fk1 FOREIGH KEY(smp_sample_attribute_type_id) REFERENCES smp_sample_attribute_type, CONSTRAINT smp_sample_attribute_val_fk1 FOREIGH KEY(smp_sample_attribute_val_id) REFERENCES smp_sample_attribute_val, CONSTRAINT stn_color_fk1 FOREIGH KEY(stn_color_id) REFERENCES stn_color, CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT blank_thickness_stn_munit_fk1 FOREIGH KEY(blank_thickness_stn_munit_id) REFERENCES stn_munit, CONSTRAINT finish_thickness_stn_munit_fk1 FOREIGH KEY(finish_thickness_stn_munit_id) REFERENCES stn_munit, CONSTRAINT total_rm_stn_munit_cnvtdtl_fk1 FOREIGH KEY(total_rm_stn_munit_cnvt_dtl_id) REFERENCES stn_munit_converter_dtl, CONSTRAINT prod_item_rcp_setup_attr_pk PRIMARY KEY(id) )	setup formula on this table(13,14) to generate BOM for rm collection
7	prod_item_rcp_setup_rm	create table prod_item_rcp_setup_rm( id number(20) not null, prod_item_rcp_setup_mst_id number(20) not null, prod_item_rcp_setup_attr_id number(20) not null, stn_item_group_id number(20) not null, smp_item_setup_id number(20) not null, --[from sample module] stn_munit_id number(20) not null, percent number(4,2) not null, qty number(4,2) not null, stn_munit_cnvt_dtl_id number(4,2) not null, CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst, CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr, CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group, CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl, CONSTRAINT prod_item_rcp_setup_rm_pk PRIMARY KEY(id) )
8	prod_prdtn_process_mst	create table prod_prdtn_process_mst( id number(20) not null, production_name varchar2(50) not null, stn_item_group_id number(20) not null, smp_item_setup_id number(20) not null, stn_hrm_company_id number(20) not null, smp_sample_id number(20) default null, ord_order_id number(20) default null, CONSTRAINT stn_item_group_fk FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group, CONSTRAINT smp_item_setup_fk FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT stn_hrm_company_fk FOREIGH KEY(stn_hrm_company_id) REFERENCES stn_hrm_company, CONSTRAINT smp_sample_fk FOREIGH KEY(smp_sample_id) REFERENCES smp_sample, CONSTRAINT ord_order_fk FOREIGH KEY(ord_order_id) REFERENCES ord_order, CONSTRAINT prod_prdtn_process_mst_pk PRIMARY KEY(id) )
9	prod_prdtn_process_dtl	create table prod_prdtn_process_dtl( id number(20) not null, prod_prdtn_process_mst_id number(20) not null, unit_sts_lookup_dtl_id number(20) not null, current_prod_opunit_id number(20) not null, next_prod_opunit_id number(20) not null, step_no number(4) not null, is_active number(1) not null, work_sts_lookup_dtl_id number(20) not null, -- work in progress,done inspect_sts_lookup_dtl_id number(20) default null, -- inspected,reinspect,rejected CONSTRAINT prod_prdtn_process_mst_fk FOREIGH KEY(prod_prdtn_process_mst_id) REFERENCES prod_prdtn_process_mst, CONSTRAINT unit_sts_lookup_dtl_fk FOREIGH KEY(unit_sts_lookup_dtl_id) REFERENCES unit_sts_lookup_dtl, CONSTRAINT current_prod_opunit_fk FOREIGH KEY(current_prod_opunit_id) REFERENCES current_prod_opunit, CONSTRAINT next_prod_opunit_fk FOREIGH KEY(next_prod_opunit_id) REFERENCES next_prod_opunit, CONSTRAINT prod_prdtn_process_dtl_pk PRIMARY KEY(id) )
10	prod_rcp_brkdown_batch(rcp=recipe)	create table prod_rcp_brkdown_batch( id number(20) not null, prod_prdtn_process_dtl_id smp_sample_breakdown_id default null, ord_order_breakdown_id default null, CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl, CONSTRAINT smp_sample_breakdown_fk FOREIGH KEY(smp_sample_breakdown_id) REFERENCES smp_sample_breakdown, CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown, CONSTRAINT prod_rcp_brkdown_batch_pk PRIMARY KEY(id) )
11	prod_rcp_brkdown_batch_attr	create table prod_item_rcp_setup_attr( id number(20) not null, prod_item_rcp_setup_mst_id number(20) not null, smp_sample_attribute_type_id number(20) not null, smp_sample_attribute_val_id number(20) not null, leign varchar2(50) not null, color_id number(20) not null, blank_thickness number(4,2) not null, blank_thickness_stn_munit_id number(20) not null, finish_thickness number(4,2) not null, finish_thickness_stn_munit_id number(20) not null, sheet_rod varchar2(50) not null, req_qty number(4,2) not null, stn_munit_id number(20) not null, moq_qty number(4,2) not null, total_rm number(4,2) not null, total_rm_stn_munit_cnvt_dtl_id number(4,2) not null, total_percent number(4,2) not null, CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst, CONSTRAINT smp_sample_attribute_type_fk1 FOREIGH KEY(smp_sample_attribute_type_id) REFERENCES smp_sample_attribute_type, CONSTRAINT smp_sample_attribute_val_fk1 FOREIGH KEY(smp_sample_attribute_val_id) REFERENCES smp_sample_attribute_val, CONSTRAINT stn_color_fk1 FOREIGH KEY(stn_color_id) REFERENCES stn_color, CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT blank_thickness_stn_munit_fk1 FOREIGH KEY(blank_thickness_stn_munit_id) REFERENCES stn_munit, CONSTRAINT finish_thickness_stn_munit_fk1 FOREIGH KEY(finish_thickness_stn_munit_id) REFERENCES stn_munit, CONSTRAINT total_rm_stn_munit_cnvtdtl_fk1 FOREIGH KEY(total_rm_stn_munit_cnvt_dtl_id) REFERENCES stn_munit_converter_dtl, CONSTRAINT prod_rcp_brkdown_batch_attr_pk PRIMARY KEY(id) )	setup formula on this table(13,14) to generate BOM for rm collection
12	prod_rcp_brkdown_batch_rm	create table prod_rcp_brkdown_batch_rm( id number(20) not null, prod_rcp_brkdown_batch_id number(20) not null, prod_item_rcp_setup_mst_id number(20) not null, --[ from prod_item_rcp_setup_mst] prod_rcp_brkdown_batch_attr_id number(20) not null, --[ update tale of prod_item_rcp_setup_attr] stn_item_group_id number(20) not null, smp_item_setup_id number(20) not null, --[from sample module] stn_munit_id number(20) not null, percent number(4,2) not null, qty number(4,2) not null, stn_munit_cnvt_dtl_id number(4,2) not null, cur_prod_opunit_id number(20) not null, next_prod_opunit_id number(20) default null, sumit_date datetime default null, is_lock numer(2) not null, CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown, CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst, CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr, CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group, CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl, CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT prod_rcp_brkdown_batch_rm_pk PRIMARY KEY(id) )
13	prod_rqsn_brkdown_batch_rm(rqsn = requisition)	create table prod_rqsn_brkdown_batch_rm( id number(20) not null, prod_rcp_brkdown_batch_id number(20) not null, prod_item_rcp_setup_mst_id number(20) not null, --[ from prod_item_rcp_setup_mst] prod_rcp_brkdown_batch_attr_id number(20) not null, --[ update tale of prod_item_rcp_setup_attr] stn_item_group_id number(20) not null, smp_item_setup_id number(20) not null, --[from sample module] stn_munit_id number(20) not null, percent number(4,2) not null, qty number(4,2) not null, stn_munit_cnvt_dtl_id number(4,2) not null, inv_warehouse_id number(20) default null, inv_store_id number(20) default null, cur_prod_opunit_id number(20) not null, next_prod_opunit_id number(20) default null, sumit_date datetime default null, is_lock numer(2) not null, CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown, CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst, CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr, CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group, CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl, CONSTRAINT inv_warehouse_fk1 FOREIGH KEY(inv_warehouse_id) REFERENCES inv_warehouse, CONSTRAINT inv_store_fk1 FOREIGH KEY(inv_store_id) REFERENCES inv_store, CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT prod_rqsn_brkdown_batch_rm_pk PRIMARY KEY(id) )
14	prod_recv_brkdown_batch_rm(recv = receive)	create table prod_recv_brkdown_batch_rm( id number(20) not null, prod_rcp_brkdown_batch_id number(20) not null, prod_item_rcp_setup_mst_id number(20) not null, --[ from prod_item_rcp_setup_mst] prod_rcp_brkdown_batch_attr_id number(20) not null, --[ update tale of prod_item_rcp_setup_attr] stn_item_group_id number(20) not null, smp_item_setup_id number(20) not null, --[from sample module] stn_munit_id number(20) not null, percent number(4,2) not null, qty number(4,2) not null, stn_munit_cnvt_dtl_id number(4,2) not null, inv_warehouse_id number(20) default null, inv_store_id number(20) default null, cur_prod_opunit_id number(20) not null, next_prod_opunit_id number(20) default null, sumit_date datetime default null, is_lock numer(2) not null, CONSTRAINT ord_order_breakdown_fk FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown, CONSTRAINT prod_item_rcp_setup_mst_fk1 FOREIGH KEY(prod_item_rcp_setup_mst_id) REFERENCES prod_item_rcp_setup_mst, CONSTRAINT prod_item_rcp_setup_attr_fk1 FOREIGH KEY(prod_item_rcp_setup_attr_id) REFERENCES prod_item_rcp_setup_attr, CONSTRAINT stn_item_group_fk1 FOREIGH KEY(stn_item_group_id) REFERENCES stn_item_group, CONSTRAINT smp_item_setup_fk1 FOREIGH KEY(smp_item_setup_id) REFERENCES smp_item_setup, CONSTRAINT stn_munit_fk1 FOREIGH KEY(stn_munit_id) REFERENCES stn_munit, CONSTRAINT stn_munit_cnvt_dtl_fk1 FOREIGH KEY(stn_munit_cnvt_dtl_id) REFERENCES stn_munit_cnvt_dtl, CONSTRAINT inv_warehouse_fk1 FOREIGH KEY(inv_warehouse_id) REFERENCES inv_warehouse, CONSTRAINT inv_store_fk1 FOREIGH KEY(inv_store_id) REFERENCES inv_store, CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT prod_recv_brkdown_batch_rm_pk PRIMARY KEY(id) )
15	prod_process_tools	create table prod_process_tools( id number(20) not null, prod_prdtn_process_dtl_id prod_unit_id number(20) not null, prod_tools_id number(20) not null, cur_prod_opunit_id number(20) not null, CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl, CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit, CONSTRAINT prod_tools_fk FOREIGH KEY(prod_tools_id) REFERENCES prod_tools, CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT prod_process_tools_pk PRIMARY KEY(id) )
16	prod_process_tools_time	create table prod_process_tools_output( id number(20) not null, prod_process_tools_id number(20) not null, start_time datetime default null, end_time datetime default null, cur_prod_opunit_id number(20) not null, CONSTRAINT prod_process_tools_fk FOREIGH KEY(prod_process_tools_id) REFERENCES prod_process_tools, CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT prod_process_tools_output_pk PRIMARY KEY(id) )
17	prod_process_tools_output	create table prod_process_tools_output( id number(20) not null, prod_process_tools_id number(20) not null, date_time datetime not null, output_name varchar2(50) not null, output_qty number(4,2) not null, wast_qty number(4,2) not null, cur_prod_opunit_id number(20) not null, next_prod_opunit_id number(20) default null, sumit_date datetime default null, is_lock numer(2) not null, CONSTRAINT prod_process_tools_fk FOREIGH KEY(prod_process_tools_id) REFERENCES prod_process_tools, CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT next_prod_opunit_fk1 FOREIGH KEY(next_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT prod_process_tools_output_pk PRIMARY KEY(id) )	multiple record insert allowed
18	prod_process_asn_timeline	create table prod_process_asn_timeline( id number(20) not null, prod_prdtn_process_dtl_id number(20) not null, prod_unit_id number(20) not null, start_time datetime default null, end_time datetime default null, extend_time datetime default null, actual_finish_time datetime default null, cur_prod_opunit_id number(20) not null, CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl, CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit, CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT prod_process_asn_timeline_pk PRIMARY KEY(id) )
19	prod_process_asn_comment	create table prod_process_asn_timeline( id number(20) not null, prod_prdtn_process_dtl_id number(20) not null, prod_unit_id number(20) not null, comment varchar2(50) default null, cur_prod_opunit_id number(20) not null, CONSTRAINT prod_prdtn_process_dtl_fk FOREIGH KEY(prod_prdtn_process_dtl_id) REFERENCES prod_prdtn_process_dtl, CONSTRAINT prod_unit_fk FOREIGH KEY(prod_unit_id) REFERENCES prod_unit, CONSTRAINT cur_prod_opunit_fk1 FOREIGH KEY(cur_prod_opunit_id) REFERENCES prod_opunit, CONSTRAINT prod_process_asn_comment_pk PRIMARY KEY(id) )
20	prod_delivery_challan	create table prod_delivery_challan( id number(20) not null, prod_prdtn_process_mst_id number(20) not null, delivery_man varchar2(50) default null, driver varchar2(50) default null, vehicle_no varchar2(50) default null, delivery_note_date date default null, delivery_note_type varchar2(50) default null, delivery_note_received varchar2(50) default null, bill_challan_no varchar2(50) default null, bill_challan_date date default null, is_bill_prepared number(2) not null, remarks varchar2(100) default null, inv_warehouse_id number(20) default null, inv_store_id number(20) default null, is_received number(2) default null, received_date date default null, received_by varchar2(50) default null, CONSTRAINT prod_prdtn_process_mst_fk1 FOREIGH KEY(prod_prdtn_process_mst_id) REFERENCES prod_prdtn_process_mst, CONSTRAINT prod_delivery_challan_pk PRIMARY KEY(id) )
21	prod_challan_batch	create table prod_challan_batch( id number(20) not null, prod_delivery_challan_id number(20) not null, smp_sample_breakdown_id default null, ord_order_breakdown_id default null, CONSTRAINT prod_delivery_challan_fk1 FOREIGH KEY(prod_delivery_challan_id) REFERENCES prod_delivery_challan, CONSTRAINT smp_sample_breakdown_fk1 FOREIGH KEY(smp_sample_breakdown_id) REFERENCES smp_sample_breakdown, CONSTRAINT ord_order_breakdown_fk1 FOREIGH KEY(ord_order_breakdown_id) REFERENCES ord_order_breakdown, CONSTRAINT prod_challan_batch_pk PRIMARY KEY(id) )

Latest Tutorial