tsdf
Tables (7)
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_no — INT — Primary key — NOT NULL
- user_id — VARCHAR(20) — Foreign key → members.user_id — NOT NULL
- subject — VARCHAR(255) — NOT NULL
- content — TEXT
- hit — INT
- register_time — TIMESTAMP
- INDEX — `board_to_memebers_member_id_fk_idx`
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`
members
- user_id — VARCHAR(16) — Primary key — NOT NULL
- user_name — VARCHAR(20) — NOT NULL
- user_password — VARCHAR(16) — NOT NULL
- email_id — VARCHAR(20)
- email_domain — VARCHAR(45)
- join_date — TIMESTAMP — NOT NULL
sido
- sido_code — INT — Primary key — NOT NULL
- sido_name — VARCHAR(30)