q

Tables (6)

Contents

  • content_id — bigint — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • description — text
  • category — varchar(50)
  • mbti_strength — varchar(50)

ContestEntry

  • contestEntry_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • entry_date — timestamp
  • entry_rank — int

Diagnosis

  • diagnosis_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • mbti_id — bigint — Foreign key → MBTI.mbti_id — NOT NULL
  • diagnosis_date — date — NOT NULL
  • result — text

Feedback

  • feedback_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • content_id — bigint — Foreign key → Contents.content_id — NOT NULL
  • feedback_type — varchar(50)
  • feedback_date — date — NOT NULL

MBTI

  • mbti_id — bigint — Primary key — NOT NULL
  • type — varchar(10) — NOT NULL
  • description — varchar(255)

User

  • user_id — bigint — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • email — varchar(100) — NOT NULL
  • mbti_id — bigint — Foreign key → MBTI.mbti_id