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