walkmate

Tables (3)

Member (유저)

  • memberId (Key) — varchar — Primary key — NOT NULL
  • name (이름) — string — NOT NULL
  • email (이메일) — string — NOT NULL

Recent Destination (최근 목적지)

  • recentDestinationId (Key) — Primary key — NOT NULL
  • memberId (Key2) — Foreign key → Member.memberId — NOT NULL
  • name (목적지 이름) — string — NOT NULL
  • address (주소) — string — NOT NULL

bookmark (즐겨찾기)

  • bookmarkId (Key) — Primary key — NOT NULL
  • memberId (Key2) — Foreign key → Member.memberId — NOT NULL
  • name (즐겨 찾는 장소 이름) — string — NOT NULL
  • address (주소) — string — NOT NULL