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