Nextree gate 02

Tables (6)

Board (Untitled4)

  • clubId (string) — Foreign key → TravelClub.clubId — NOT NULL
  • memberEmail (Key) — Foreign key → Membership.memberEmail — NOT NULL
  • boardName (Field) — NOT NULL
  • createDate (Field2) — NOT NULL

Comment (Untitled6)

  • usid (Key) — autoIncrement — Primary key — NOT NULL
  • postingId (Key2) — Foreign key → Posting.postingId — NOT NULL
  • memberEmail (Key3) — Foreign key → Membership.memberEmail — NOT NULL
  • contents (Field2)
  • writtenDate (Field3) — NOT NULL

CommunityMember (Untitled2)

  • email (Key) — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • nickName (Field2) — NOT NULL
  • phoneNumber (Field3) — NOT NULL
  • birthDay (Field4) — NOT NULL

Membership (Untitled3)

  • clubId (string) — Foreign key → TravelClub.clubId — NOT NULL
  • memberEmail (Key) — Foreign key → CommunityMember.email — NOT NULL
  • roleInClub (Field) — NOT NULL
  • joinDate (Field2) — NOT NULL

Posting (Untitled5)

  • postingId (Key) — autoIncrement — Primary key — NOT NULL
  • clubId (string) — Foreign key → Board.clubId — NOT NULL
  • memberEmail (Key2) — Foreign key → Membership.memberEmail — NOT NULL
  • title (Field) — NOT NULL
  • contents (Field2)
  • writtenDate (Field3) — NOT NULL
  • readCount (Field4) — NOT NULL

TravelClub (Untitled)

  • clubId (string) — autoIncrement — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • intro (Field2) — NOT NULL
  • date (Field3) — NOT NULL