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 (비밀번호)