DATABASE
Tables (9)
attraction_description
- attraction_id — int — Foreign key → attraction_info.attraction_id — NOT NULL
- description — varchar(10000)
attraction_info
- attraction_id — int — Primary key — NOT NULL
- type_id — int
- title — varchar(100)
- addr — varchar(100)
- zipcode — varchar(50)
- tel — varchar(50)
- img_small — varchar(200)
- img_big — varchar(200)
- latitude — decimal(20,17)
- longitude — decimal(20,17)
- gugun_code — int — Foreign key → gugun.gugun_code — NOT NULL
- sido_code — int — Foreign key → sido.sido_code — NOT NULL
gugun
- gugun_code — int — Primary key — NOT NULL
- sido_code — int — Foreign key → sido.sido_code — NOT NULL
- sido_name — varchar(30)
member
- user_id — varchar(16) — Primary key — NOT NULL
- password — varchar(60)
- name — varchar(20)
- tel — varchar(20)
- location — varchar(20)
- join_date — timestamp
place
- plan_id — int — Foreign key → plan.plan_id — NOT NULL
- attraction_id — int — Foreign key → attraction_info.attraction_id — NOT NULL
- order — int
- start_time — datetime
- end_time — datetime
- comment — varchar(100)
plan
- plan_id — int — Primary key — NOT NULL
- regist_date — timestamp
- visibility — boolean
- comment — text
- maker_id — varchar(16) — Foreign key → member.user_id — NOT NULL
realation
- user_id — varchar(16) — Foreign key → member.user_id — NOT NULL
- user_id2 — varchar(16) — Foreign key → member.user_id — NOT NULL
- type — tinyint
sido
- sido_code — int — Primary key — NOT NULL
- sido_name — varchar(30)
tripwith
- plan_id — int — Foreign key → plan.plan_id — NOT NULL
- user_id — varchar(16) — Foreign key → member.user_id — NOT NULL