travelssafy
Tables (11)
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)
board
- article_no — INT — Primary key — NOT NULL
- user_id — VARCHAR(50) — Foreign key → member.user_id
- subject — VARCHAR(100)
- content — VARCHAR(2000)
- hit — INT
- register_time — TIMESTAMP — NOT NULL
- INDEX — `board_to_member_user_id_fk`
favorite
- favorite_id — int — Primary key — NOT NULL
- user_id — varchar(50) — Foreign key → member.user_id — NOT NULL
- content_id — int — Foreign key → attraction_info.content_id — NOT NULL
gugun
- gugun_code — int — Primary key — NOT NULL
- sido_code — int — Foreign key → sido.sido_code — NOT NULL
- gugun_name — varchar(30)
member
- user_id — varchar(50) — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(255)
- sido_code — int — Foreign key → sido.sido_code — NOT NULL
- gugun_code — int — Foreign key → gugun.gugun_code — NOT NULL
- is_active — int
memo
- memo_no — INT — Primary key — NOT NULL
- user_id — VARCHAR(50) — Foreign key → member.user_id
- comment — VARCHAR(500)
- memo_time — TIMESTAMP — NOT NULL
- article_no — INT — Foreign key → board.article_no
- parent_memo_no — INT — Foreign key → memo.memo_no
- INDEX — `memo_to_board_article_no_fk`
- INDEX — `memo_to_member_fk_idx`
plan
- plan_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(50) — Foreign key → member.user_id — NOT NULL
- title — VARCHAR(255)
- memo — VARCHAR(1000)
plan_detail
- planDetail_id — INT — Primary key — NOT NULL
- plan_id — INT — Foreign key → plan.plan_id — NOT NULL
- content_id — INT — Foreign key → attraction_info.content_id — NOT NULL
- sequence — INT — NOT NULL
sido
- sido_code — int — Primary key — NOT NULL
- sido_name — varchar(30)