ㄷㄷㄷ
Tables (13)
attraction_description
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
- homepage — VARCHAR(100)
- overview — VARCHAR(10000)
- telname — VARCHAR(45)
attraction_detail
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
- cat1 — VARCHAR(3)
- cat2 — VARCHAR(5)
- cat3 — VARCHAR(9)
- created_time — VARCHAR(14)
- modified_time — VARCHAR(14)
- booktour — VARCHAR(5)
attraction_info
- content_id — INT — Primary key — NOT NULL
- content_type_id — INT
- title — VARCHAR(100)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(50)
- zipcode — VARCHAR(50)
- tel — VARCHAR(50)
- first_image — VARCHAR(200)
- first_image2 — VARCHAR(200)
- readcount — INT
- sido_code — INT — Foreign key → sido.sido_code
- gugun_code — INT — Foreign key → gugun.gugun_code
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
- mlevel — VARCHAR(2)
- INDEX — `attraction_to_content_type_id_fk_idx`
- INDEX — `attraction_to_sido_code_fk_idx`
- INDEX — `attraction_to_gugun_code_fk_idx`
board
- article_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(50) — Foreign key → member.user_id — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- register_time — DATETIME — NOT NULL
- isdelete — INT — NOT NULL
- INDEX — `user_id`
detail_plan
- detail_plan_id — INT — Primary key — NOT NULL
- trip_plan_id — INT — Foreign key → trip_plan.trip_plan_id — NOT NULL
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
- sequence — INT — NOT NULL
- INDEX — `trip_plan_id`
- INDEX — `content_id`
gugun
- gugun_code — INT — Primary key — NOT NULL
- sido_code — INT — Foreign key → sido.sido_code — NOT NULL
- gugun_name — VARCHAR(30)
- INDEX — `gugun_to_sido_sido_code_fk_idx`
hotplace
- user_id — VARCHAR(50) — Foreign key → member.user_id — NOT NULL
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
- desc — VARCHAR(500)
- INDEX — `user_id`
- INDEX — `content_id`
member
- user_id — VARCHAR(50) — Primary key — NOT NULL
- password — VARCHAR(50) — NOT NULL
- name — VARCHAR(30) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- joinDate — DATETIME — NOT NULL
- authority — INT — NOT NULL
- isdelete — INT — NOT NULL
movies
- ID — INT — Primary key — NOT NULL
- Title — VARCHAR(40) — NOT NULL
- Director — VARCHAR(40) — NOT NULL
- Genre — VARCHAR(40) — NOT NULL
- RunningTime — INT — NOT NULL
notice
- article_id — INT — Primary key — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- register_time — DATETIME — NOT NULL
sido
- sido_code — INT — Primary key — NOT NULL
- sido_name — VARCHAR(30)
ssafy_member
- idx — INT — Primary key — NOT NULL
- userid — VARCHAR(16) — NOT NULL
- username — VARCHAR(20)
- userpwd — VARCHAR(16)
- emailid — VARCHAR(20)
- emaildomain — VARCHAR(50)
- joindate — TIMESTAMP
trip_plan
- trip_plan_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(50) — Foreign key → member.user_id
- title — VARCHAR(50)
- INDEX — `user_id`