codelab

Tables (3)

administrative_area

  • id — SERIAL — Primary key
  • level_id — INTEGER — Foreign key → administrative_level.id
  • parent_id — INTEGER
  • name — VARCHAR(100) — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • boundary — geometry(MULTIPOLYGON, 4326) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_active — BOOLEAN

administrative_level

  • id — SERIAL — Primary key
  • name — VARCHAR(20) — NOT NULL
  • display_name — VARCHAR(20) — NOT NULL
  • order — INTEGER — NOT NULL

area_code_mapping

  • id — SERIAL — Primary key
  • area_id — INTEGER — Foreign key → administrative_area.id
  • code_type — VARCHAR(50) — NOT NULL
  • code_value — VARCHAR(50) — NOT NULL
  • is_primary — BOOLEAN