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)