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