ggg
Tables (7)
grass
- grass_id — SERIAL — Primary key — NOT NULL
- user_id — int2 — Foreign key → user.user_id — NOT NULL
- pnu — bigint — Foreign key → place.pnu — NOT NULL
- map_id — bigint — Foreign key → map.map_id — NOT NULL
- created_at — timestamp — NOT NULL
- is_private — boolean — NOT NULL
grass_view
- map_id — bigint
- map_code — bigint
- x — int2
- y — int2
- commit_count — int2
map
- map_id — bigint — Primary key — NOT NULL
- map_code — bigint — NOT NULL
- zone_code — int4 — NOT NULL
- x — int2 — NOT NULL
- y — int2 — NOT NULL
- map_level — int2
place
- pnu — bigint — Primary key — NOT NULL
- name — TEXT — NOT NULL
- address — TEXT — NOT NULL
place_map
- pnu — bigint — Foreign key → place.pnu — NOT NULL
- map_id — bigint — Foreign key → map.map_id — NOT NULL
subzone
- sub_zone_code — bigint — Primary key — NOT NULL
- map_id — bigint — Foreign key → map.map_id — NOT NULL
user
- user_id — int2 — Primary key — NOT NULL
- user_name — varchar(255) — NOT NULL
- created_at — timestamp — NOT NULL