nutrifood_development - Laravel Schema Designer

RAP

id increments
tahun integer
tgl_sk datetime
no_sk string
cust_desc string
cust_site_ship_code string
cust_site_ship_desc string
kota string
region string
brand string
category string
product_code string
product_desc string
jenis_alokasi string
top_alokasi float
harga float
qty_alokasi float
tgl_kirim datetime
qty_kirim float
value_kirim float
alokasi_tidak_kirim float
sisa_alokasi float
value_sisa_alokasi float
keterangan string
filter_alokasi string
timestamps timestamps

FSD

id increments
file_id string
distributor_code string
distributor_name string
no_po string
status string
input_date datetime
pricelist_code string
requested_delivery_date string
order_type string
top_reguler integer
kubikasi_gimmick string
kubikasi string
item_code string
item_desc string
avg_sales_value float
avg_sales_karton float
stock_qty_karton float
stock_qty_pcs float
stock_nilai float
stock_intransit_karton float
stock_intransit_nilai float
order_rumus_karton float
order_rumus_nilai float
order_alokasi_karton float
order_alokasi_nilai float
total_order_karton float
total_order_nilai float
total_order_kubikasi float
adjusment_distributor_karton float
adjusment_distributor_nilai float
adjusment_nfi_karton float
adjusment_nfi_nilai float
order_final_karton float
order_final_nilai float
order_final_kubikasi float
stock_gudang float
stock_qty_karton_ed3 float
stock_qty_pcs_ed3 float
stock_qty_karton_ed6 float
stock_qty_pcs_ed6 float
stock_qty_karton_ed9 float
stock_qty_pcs_ed9 float
discount_retur float
cash_discount float
timestamps timestamps

FOD

id increments
line_id integer
fod_no string
line_no integer
product_code string
product_desc string
order_qty float
jenis_alokasi string
discount_pct float
discount_retur float
kubikasi float
tonase float
filename string
timestamps timestamps

cancel_backorder

id increments
timestamps timestamps
order_type string
status string
item_code string
item_description string
order_no string
ordered_date datetime
order_qty float
unit_sales string
cust_code string
cust_site_number integer
cust_desc string
location string

Dim_Product

id increments
product_key integer
product_id integer
product_code string
product_desc string
principal string
brand string
flavor string
packaging string
sub_packaging string
kelompok string
channel string
group_nasa string
item_group string
item_monitoring string
sub_brand string
active_status string
weight_per_qty integer
serving_per_qty integer
kdi_conversional integer
box_conversional integer
item_global_desc string
production_category string
production_sub_category string
category string
lead_time_production integer
lead_time_quarantine integer
unit_weight float
unit_volume float
source string
timestamps timestamps

Dim_Period

id increments
timestamps timestamps
period_key integer
full_date datetime
year_num smallInteger
semester_num tinyInteger
semester_name string
semester_short_name string
cawu_num tinyInteger
cawu_name string
quarter_num smallInteger
quarter_name string
month_num tinyInteger
month_name string
mont_short_name string
week_of_year tinyInteger
week_of_month tinyInteger
day_num smallInteger
day_of_week integer
day_of_year integer
day_name string
full_date_char string
occasion string
working_day string

upload_fsd

id increments
timestamps timestamps
tanggal_upload datetime
nama_file string
uploader string
status string
fod_time datetime
dist string

roles

id increments
role_name string
status integer
upload_rap boolean
upload_fsd boolean
down_temp_fsd boolean
upload_tad boolean
crud_user boolean
timestamps timestamps

users

id increments
name string
usernmae string
email string
password string
role_id string
dist string
timestamps timestamps

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01