aa
Tables (10)
delivery_sheet
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- delivery_date — date — NOT NULL
- reserved_delivery_date — date — NOT NULL
- reserved_packing_type — varchar(20) — NOT NULL
- request — text — NOT NULL
- reserved_quantity — int4 — NOT NULL
- order_id — int4 — NOT NULL
- resource_id — int4 — NOT NULL
- location_id — int4 — NOT NULL
- delivery_shipping_id — int4 — NOT NULL
delivery_shipping
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- delivery_type — varchar(20) — NOT NULL
- output_packing_type — varchar(20) — NOT NULL
- quantity — int4 — NOT NULL
- shipment_fee — int4 — NOT NULL
- etc_fee — int4 — NOT NULL
inventory
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- quantity — int4 — NOT NULL
- reserved_quantity — int4 — NOT NULL
- lot_id — int4 — NOT NULL
- resource_id — int4 — NOT NULL
- location_id — int4 — NOT NULL
location
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- name — varchar(20) — NOT NULL
- warehouse_id — int4 — NOT NULL
- inventory_id — int4
lot
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- manufacturing_lot — varchar(100) — NOT NULL
- expiration_date — date — NOT NULL
- resource_id — int4 — NOT NULL
order
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- orderer_name — varchar(100) — NOT NULL
- orderer_phone — varchar(20) — NOT NULL
- reciever_name — varchar(100) — NOT NULL
- reciever_phone — varchar(20) — NOT NULL
- reciever_address — varchar(255) — NOT NULL
- reciever_zipcode — varchar(20) — NOT NULL
- deliver_message — text — NOT NULL
receive_shipping
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- car_number — varchar(9) — NOT NULL
- input_packing_type — varchar(20) — NOT NULL
- is_exist_multi_resource_packing — bool — NOT NULL
- multi_resource_packing_quantity — int4 — NOT NULL
- pallet_quantity — int4 — NOT NULL
- box_quantity — int4 — NOT NULL
- cash_on_delivery_cost — int4 — NOT NULL
- input_cost — int4 — NOT NULL
receiving_sheet
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- receiving_date — date — NOT NULL
- receiving_type — varchar(50) — NOT NULL
- quantity — int4 — NOT NULL
- packing_type — varchar(20) — NOT NULL
- delivery_type — varchar(20) — NOT NULL
- is_checked — bool — NOT NULL
- receive_shipping_id — int4
- resource_id — int4 — NOT NULL
- location_id — int4
resource
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- brand — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- invoice_output_name — varchar(100) — NOT NULL
- logistics_send_name — varchar(100) — NOT NULL
- resource_code — varchar(100) — NOT NULL
- barcode — varchar(20) — NOT NULL
- option — varchar(50) — NOT NULL
- selling_price — int4 — NOT NULL
- cost_price — int4 — NOT NULL
- manufacturing_lot_enable — bool — NOT NULL
- expiration_date_enable — bool — NOT NULL
- default_location_id — int4 — NOT NULL
warehouse
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- name — varchar(20) — NOT NULL
- input_enable — bool — NOT NULL
- output_enable — bool — NOT NULL
- store_enable — bool — NOT NULL
- address — varchar(100) — NOT NULL
- phone_number — varchar(20) — NOT NULL