Glass bottle

Tables (8)

letter (Untitled7)

  • id — Long — Primary key — NOT NULL
  • senderMbtiId — Long
  • receiverMbtiId — Long
  • title — String
  • content — String
  • state — String

letter_invoice (Untitled8)

  • id — Long — Primary key — NOT NULL
  • snderUserId (senderUserId) — Long
  • reciverUserId — Long
  • id (id2) — Long — Foreign key → letter.id — NOT NULL
  • uid (id3) — Long — Foreign key → member.uid — NOT NULL

mbti_metadate (Untitled2)

  • mbti_metadata_idid (id) — Long — Primary key — NOT NULL
  • type — String
  • name — String
  • description — String

mbti_quiz (Untitled3)

  • id — Long — Primary key — NOT NULL
  • seq — Integer
  • content — String
  • id (id2) — Long — Foreign key → mbti_quiz_round.mbti_quiz_round_id — NOT NULL

mbti_quiz_history (Untitled4)

  • id — Long — Primary key — NOT NULL
  • result (reult) — MbtiResult
  • id (id2) — Long — Foreign key → mbti_quiz_round.mbti_quiz_round_id — NOT NULL
  • uid (id3) — Long — Foreign key → member.uid — NOT NULL

mbti_quiz_round (Untitled5)

  • mbti_quiz_round_id (id) — Long — Primary key — NOT NULL
  • round — String
  • description — String

member (Untitled)

  • uid (id) — Long — Primary key — NOT NULL
  • email — String
  • password — String
  • mbti (mbtiId) — Long
  • roleType — RoleType

member_mbti (Untitled6)

  • id — Long — Primary key — NOT NULL
  • uid (id2) — Long — Foreign key → member.uid — NOT NULL
  • id (id3) — Long — Foreign key → mbti_metadate.mbti_metadata_idid — NOT NULL