mojungforest
Tables (6)
Message (Untitled2)
- _id (Key) — Primary key — NOT NULL
- generatorId (Key2) — int — Foreign key → User._id — NOT NULL
- recepient (Field) — string
- content (Field2) — string
- createdAt (Field3)
MessageEmotion (Untitled4)
- _id (Key) — Primary key — NOT NULL
- messageId (Key2) — Foreign key → Message._id — NOT NULL
- userId (Key3) — Foreign key → User._id — NOT NULL
- emotionNum (Field2) — int
User (Untitled)
- _id (Key) — Primary key — NOT NULL
- userId (아이디) — string
- password (비번) — int
- name (Field)
- status (상태) — string
- createdAt (생성날짜) — date
UserVote (Untitled6)
- _id (Key) — Primary key — NOT NULL
- userId (Key2) — Foreign key → User._id — NOT NULL
- voteId (Key3) — Foreign key → Vote._id — NOT NULL
- optionNum (Field)
Vote (Untitled3)
- _id (Key) — Primary key — NOT NULL
- generatorId (Key2) — Foreign key → User._id — NOT NULL
- title (Field)
- option1 (Field2)
- option2 (Field3)
- option3 (Field4)
- option4 (Field5)
- option5 (Field6)
- createdAt (Field7)
VoteEmotion (Untitled5)
- _id (Key) — Primary key — NOT NULL
- userId (Key2) — Foreign key → User._id — NOT NULL
- voteId (Key3) — Foreign key → Vote._id — NOT NULL
- emotionNum (Field)