Local_Friends

Tables (6)

Contents (Untitled3)

  • 콘텐츠ID (Contents_id) — not null — Primary key — NOT NULL
  • 유저ID (User_id) — not null — Foreign key → USER.유저ID — NOT NULL
  • 설명 (Description) — null
  • 가격 (Cost) — null

Copy Of Request (CopyOfUntitled4)

  • 요청ID (Request_id) — not null — Primary key — NOT NULL
  • 유저ID (User_id) — not null — Foreign key → USER.유저ID — NOT NULL
  • 생성일 (Created_date) — not null
  • 여행지 (Location) — null

Request (Untitled4)

  • 요청ID (Request_id) — not null — Primary key — NOT NULL
  • 유저ID (User_id) — not null — Foreign key → USER.유저ID — NOT NULL
  • 생성일 (Created_date) — not null
  • 여행지 (Location) — null
  • 취향1 (tag1) — null
  • 취향2 (tag2) — null
  • 취향3 (tag3) — null

Room (Untitled2)

  • 객실ID (Room_id) — not null — Primary key — NOT NULL
  • 유저ID (User_id) — not null — Foreign key → USER.유저ID — NOT NULL
  • 설명 (Description) — null

Tag (Untitled5)

  • 취향ID (Tag_id) — not null — Primary key — NOT NULL
  • 취향Name (Tag_name) — not null

USER (Untitled)

  • 유저ID (User_id) — not null — Primary key — NOT NULL
  • 비밀번호 (PW) — not null
  • 주소 (Address) — null