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