a
Tables (10)
change_history
- 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
- reason — varchar(100) — NOT NULL
- receiving_unit_id — int4
- delivery_unit_id — int4
- source_inventory_id — int4
- target_inventory_id — int4
delivery_sheet
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- date — date — NOT NULL
- reserved_date — date — NOT NULL
- reason — varchar(50) — NOT NULL
- packing_type — varchar(20) — NOT NULL
- request — text — NOT NULL
- is_checked — bool — NOT NULL
- shipping_type — varchar(20) — NOT NULL
- quantity — int4 — NOT NULL
- shipping_fee — int4 — NOT NULL
- etc_fee — int4 — NOT NULL
- 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
- shipping_message — text — NOT NULL
- delivery_unit_id — int4 — NOT NULL
delivery_unit
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- quantity — int4 — NOT NULL
- resource_id — int4 — NOT NULL
- location_id — int4 — NOT NULL
- delivery_sheet_id — int4
inventory
- id — serial4 — Primary key — NOT NULL
- id (id2) — serial4 — Foreign key → resource.id — 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 — 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
receiving_sheet
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- reserve_date — date — NOT NULL
- date — date — NOT NULL
- reason — varchar(50) — NOT NULL
- shipping_type — varchar(20) — NOT NULL
- issue — text — NOT NULL
- is_checked — bool — NOT NULL
- 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_unit_id — int4 — NOT NULL
receiving_unit
- id — serial4 — Primary key — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- reserve_quantity — int4 — NOT NULL
- quantity — int4 — NOT NULL
- packing_type — varchar(20) — NOT NULL
- resource_id — int4 — NOT NULL
- location_id — int4
- receiving_sheet_id — int4 — NOT NULL
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
- product_code — varchar(100) — NOT NULL
- barcode — varchar(20) — NOT NULL
- option — varchar(50) — NOT NULL
- selling_price — int4 — NOT NULL
- cost — 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