vngTripMap

Tables (5)

Likes

  • Key (좋아요ID) — BIGINT — Primary key — NOT NULL
  • Key (멤버ID) — BIGINT — Foreign key → Member.Key — NOT NULL
  • Key (장소ID) — BIGINT — Foreign key → Place.Key — NOT NULL

Member

  • Key (멤버ID) — BIGINT — Primary key — NOT NULL
  • Field (아이디) — STRING
  • Field (비밀번호) — STRING

Place

  • Key (장소ID) — BIGINT — Primary key — NOT NULL
  • Field (관광지명) — STRING
  • Field (순위) — INT
  • Field (주소) — STRING
  • Field (카테고리) — STRING
  • Field (검색수) — INT

Reply

  • Key (의견ID) — BIGINT — Primary key — NOT NULL
  • Key (멤버ID) — BIGINT — Foreign key → Member.Key — NOT NULL
  • Key (장소ID) — BIGINT — Foreign key → Place.Key — NOT NULL
  • Field (내용) — STRING

Route

  • Key (경로ID) — BIGINT — Primary key — NOT NULL
  • Key (멤버ID) — BIGINT — Foreign key → Member.Key — NOT NULL
  • Key (장소ID) — BIGINT — Foreign key → Place.Key — NOT NULL