321
Tables (7)
article (게시물)
- article_id (id) — Primary key — NOT NULL
- user_id (user id) — Foreign key → user.user_id — NOT NULL
- title (제목)
- body (내용)
- article_type (타입)
comment (댓글)
- comment_id (id) — Primary key — NOT NULL
- user_id (id2) — Foreign key → user.user_id — NOT NULL
photo (사진)
- photo_id (id) — Primary key — NOT NULL
- object_id (참조 id)
- photo_type (참조 타입)
spot (명소)
- spot_id (id) — Primary key — NOT NULL
- article_id (article id) — Foreign key → article.article_id — NOT NULL
- spot_type (카테고리)
- xy (좌표)
trip (여행)
- trip_id (id) — Primary key — NOT NULL
- article_id (article id) — Foreign key → article.article_id — NOT NULL
- from_day (출발일)
- to_day (종료일)
trip_schedule (여행일정)
- trip_schedule_id (id) — Primary key — NOT NULL
- trip_id (trip id) — Foreign key → trip.trip_id — NOT NULL
- spot_id (spot id) — Foreign key → spot.spot_id — NOT NULL
- day (일자)
- from_time (시작시간)
- to_time (종료시간)
- amount (금액)
user (사용자)
- user_id (id) — Primary key — NOT NULL
- name (이름)
- user_no (계정)
- password (비밀번호)