Capstone
Tables (8)
Untitled (Apt_Master)
- Key (apt_id) — INTEGER — Primary key — NOT NULL
- Field (name) — VARCHAR
- Field2 (lat) — DOUBLE
- Field3 (total_households) — INTEGER
- Field4 (build_year) — INTEGER
- Field (lng) — DOUBLE
Untitled (Apt_Trade)
- Key (trade_id) — INTEGER — Primary key — NOT NULL
- Field (price) — INTEGER
- Field (area) — DOUBLE
- Field (trade_date) — VARCHAR
- Key (apt_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Untitled (News_info)
- Key (news_id) — INTEGER — Primary key — NOT NULL
- Field (title) — VARCHAR
- Field (summary) — Text
- Field (link) — VARCHAR
- Field (original_link) — VARCHAR
- Field (publish_date) — VARCHAR
- Field (Source) — VARCHAR
- Field (region_code) — VARCHAR
- Field (created_at) — TIMESTAMP
- Key (apt_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Untitled (News_Raw)
- Key (news_id) — INTEGER — Primary key — NOT NULL
- Key (news_id2) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Field (url) — VARCHAR
- Field (created_at) — Timestamp
- Field2 (content_text) — TEXT
- Field (checksum) — Varchar
Untitled (Rebuild_Status_Current)
- Key (apt_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Field (stage) — VARCHAR
- Field (stage_updated_at) — TIMESTAMP
- Field (approval_date) — VARCHAR
- Field (management_disposal_date) — VARCHAR
- Field (expected_households) — INTEGER
- Field (updated_date) — TIMESTAMP
- Key (is_rebuild_cancdidate) — BOOLEAN — NOT NULL
Untitled (Rebuild_status_History)
- Key (history_id) — INTEGER — Primary key — NOT NULL
- Field (stage) — VARCHAR
- Field (effective_from) — TIMESTAMP
- Field (effective_to) — TIMESTAMP
- Key (apt_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
- Key (evidence_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
Untitled (Data_Evidence)
- Key (evidence_id) — INTEGER — Primary key — NOT NULL
- Field (source_type) — VARCHAR
- Field (source_url) — VARCHAR
- Field (collected_at) — TIMESTAMP
- Field (raw_payload) — JSON
Untitled (Subway_info)
- Key (station_id) — INTEGER — Primary key — NOT NULL
- Field (station_name) — VARCHAR
- Field (line) — VARCHAR
- Field (lat) — DOUBLE
- Field (lng) — DOUBLE