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