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