NETLOG

Tables (10)

collection_plan

  • plan_id — UUID
  • manager_id — UUID — Foreign key → netspa_manager.manager_id — NOT NULL
  • status — plan_status — NOT NULL
  • planned_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

collection_plan_site

  • plan_id — UUID — Foreign key → collection_plan.plan_id — NOT NULL
  • site_id — UUID — Foreign key → site.site_id — NOT NULL
  • expected_bag_count — INT

collection_record

  • collection_id — UUID
  • plan_id — UUID — Foreign key → collection_plan.plan_id — NOT NULL
  • manager_id — UUID — Foreign key → netspa_manager.manager_id — NOT NULL
  • total_weight_kg — NUMERIC(10,2) — NOT NULL
  • collected_at — TIMESTAMPTZ — NOT NULL

collection_site_detail

  • detail_id — UUID
  • collection_id — UUID — Foreign key → collection_record.collection_id — NOT NULL
  • site_id — UUID — Foreign key → site.site_id — NOT NULL
  • bag_count — INT — NOT NULL
  • weight_kg — NUMERIC(10,2)
  • completed_at — TIMESTAMPTZ — 운반자

inspection_record

  • record_id — UUID
  • site_id — UUID — Foreign key → site.site_id — NOT NULL
  • inspector_id — UUID — Foreign key → inspector.inspector_id — NOT NULL
  • vessel_name — TEXT — NOT NULL
  • vessel_image_url — TEXT — 원본
  • bag_count — INT — NOT NULL — 검수
  • inspected_at — TIMESTAMPTZ — NOT NULL

inspector

  • inspector_id — UUID
  • site_id — UUID — Foreign key → site.site_id — NOT NULL
  • name — TEXT — NOT NULL
  • login_id — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

lot

  • lot_id — UUID
  • collection_id — UUID — Foreign key → collection_record.collection_id — NOT NULL
  • status — lot_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • processed_at — TIMESTAMPTZ — 펠릿

lot_composition

  • lot_id — UUID — Foreign key → lot.lot_id — NOT NULL
  • site_id — UUID — Foreign key → site.site_id — NOT NULL
  • bag_count — INT — NOT NULL
  • weight_kg — NUMERIC(10,2) — NOT NULL
  • ratio_pct — NUMERIC(5,2) — NOT NULL

netspa_manager

  • manager_id — UUID
  • name — TEXT — NOT NULL
  • role — manager_role — NOT NULL
  • password_hash — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

site

  • site_id — UUID
  • name — TEXT — NOT NULL
  • region — TEXT — NOT NULL
  • address — TEXT
  • latitude — NUMERIC(9,6) — NOT NULL
  • longitude — NUMERIC(9,6) — NOT NULL
  • is_active — BOOLEAN — NOT NULL — Phase
  • created_at — TIMESTAMPTZ — NOT NULL