enjoyTrip
Tables (9)
attraction_category
- category_id — INT — Primary key — NOT NULL
- name — VARCHAR(50)
attraction_info
- attraction_id — INT — Primary key — NOT NULL
- sido_code — INT — Foreign key → sido.sido_code — NOT NULL
- gugun_code — INT — Foreign key → gugun.gugun_code — NOT NULL
- category_id — INT — Foreign key → attraction_category.category_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- addr — VARCHAR(100) — NOT NULL
- image — VARCHAR(200) — NOT NULL
- latitude — DECIMAL(20,17) — NOT NULL
- longtitude — DECIMAL(20,17) — NOT NULL
- INDEX — `sido_code`
- INDEX — `gugun_code`
- INDEX — `category_id`
gugun
- gugun_code — INT — Primary key — NOT NULL
- sido_code — INT — NOT NULL
likes
- member_id — INT — Foreign key → member.member_id — NOT NULL
- post_id — INT — Foreign key → post.post_id — NOT NULL
- INDEX — `post_id`
member
- member_id — INT — Primary key — NOT NULL
- id — VARCHAR(20) — NOT NULL
- password — VARCHAR(20) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(10) — NOT NULL
- authority_type — INT — NOT NULL
post
- post_id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → member.member_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- hit — INT — NOT NULL
- modified_date — TIMESTAMP — NOT NULL
- is_notion — TINYINT(1) — NOT NULL
- INDEX — `member_id`
sido
- sido_code — INT — Foreign key → gugun.sido_code — NOT NULL
- sido_name — VARCHAR(30)
trip_plan
- trip_plan_id — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → member.member_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- modified_date — TIMESTAMP — NOT NULL
- INDEX — `member_id`
tripdetail
- trip_plan_id — INT — Foreign key → trip_plan.trip_plan_id — NOT NULL
- attraction_id — INT — Foreign key → attraction_info.attraction_id — NOT NULL
- seq — INT — NOT NULL
- INDEX — `trip_plan_id`
- INDEX — `attraction_id`