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