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