Some-Where

Tables (6)

camping

  • id — Long — Primary key — NOT NULL
  • place_name — varchar(255)
  • Field2 (region) — varchar(255)
  • Field (city) — varchar(255)
  • Field2 (lat) — double
  • Field3 (lng) — double
  • Field4 (post_num) — int
  • Field5 (road_address) — varchar(255)
  • Field (address) — varchar(255)
  • Field2 (phone_num) — varchar(255)
  • Field3 (home_page) — varchar(255)
  • Field (owner) — varchar(255)
  • Field2 (sub_intro) — text
  • Field3 (introduce) — text
  • Field4 (created_at) — datetime
  • Field (modified_at) — datetime

camping_amenity

  • Key (id) — Primary key — NOT NULL
  • id (camping_id) — Long — Foreign key → camping.id — NOT NULL
  • Field (electric) — boolean
  • Field2 (hot_water) — boolean
  • Field3 (wifi) — boolean
  • Field4 (firewood) — boolean
  • Field5 (walk) — boolean
  • Field (water_park) — boolean
  • Field2 (mart) — boolean
  • Field3 (toilet) — int
  • Field4 (shower_room) — int
  • Field (sink) — int
  • Field2 (fireExtinguisher) — int
  • Field (play_ground) — boolean
  • Field2 (created_at) — datetime
  • Field3 (modified_at) — datetime

camping_category

  • Key (id) — bigint — Primary key — NOT NULL
  • id (camping_id) — bigint — Foreign key → camping.id — NOT NULL
  • Field (category) — varchar(255)
  • Field2 (created_at) — datetime
  • Field (modified_at) — datetime

camping_glamping (캠핑장 글램핑 시설)

  • Key (id) — Primary key — NOT NULL
  • id (camping_id) — Long — Foreign key → camping.id — NOT NULL
  • Field (bed) — boolean
  • Field2 (tv) — boolean
  • Field3 (refrigerator) — boolean
  • Field4 (internet) — boolean
  • Field5 (toilet) — boolean
  • Field6 (air_conditioner) — boolean
  • Field (heat) — boolean
  • Field (cookware) — boolean
  • Field (created_at) — datetime
  • Field (modified_at) — datetime

camping_near_amenity (캠핑장 근처시설)

  • Key (id) — Primary key — NOT NULL
  • id (camping_id) — Foreign key → camping.id — NOT NULL
  • Field (fishing) — boolean
  • Field (walk) — boolean
  • Field (beach) — boolean
  • Field (water_leisure) — boolean
  • Field (valley) — boolean
  • Field (river) — boolean
  • Field (swimming_pool) — boolean
  • Field (teenager_experience) — boolean
  • Field (rural_experience) — boolean
  • Field (children_playground) — boolean
  • Field (created_at) — datetime
  • Field (modified_at) — datetime

operate_period

  • Key (id) — Primary key — NOT NULL
  • id (camping_id) — Long — Foreign key → camping.id — NOT NULL
  • Field (weekday) — boolean
  • Field (weekend) — boolean
  • Field2 (spring) — boolean
  • Field3 (summer) — boolean
  • Field4 (autumn) — boolean
  • Field (winter) — boolean
  • Field (created_at) — datetime
  • Field2 (modified_at) — datetime