Sim Pang

Tables (8)

Comments

  • comment_id (Key) — varchar — Primary key — NOT NULL
  • comment (Field) — varchar(500) — NOT NULL
  • createdAt (Field2) — date — NOT NULL
  • content_id (Key4) — varchar(500) — Foreign key → Contents.content_id — NOT NULL
  • user_id (Key2) — varchar(100) — Foreign key → User.member_id — NOT NULL

Contents

  • content_id (Key4) — varchar — Primary key — NOT NULL
  • title (Field2) — varchar(100) — NOT NULL
  • content (Field4) — varchar(500) — NOT NULL
  • questions (Field5) — Object — NOT NULL
  • playCount (Field6) — int
  • commentCount (Field7) — int
  • likeCount (Field8) — int
  • shareCount (Field9) — int
  • createdAt (Field) — date — NOT NULL
  • type (Field3) — enum — NOT NULL

Likes

  • like_id (Key) — varchar — Primary key — NOT NULL
  • user_id (Key2) — varchar(100) — Foreign key → User.member_id — NOT NULL
  • content_id (Key4) — varchar — Foreign key → Contents.content_id — NOT NULL
  • createdAt (Field2) — date — NOT NULL

LoginHistory (Untitled)

  • LoginHistory (Key) — Primary key — NOT NULL
  • user_id (Key2) — varchar — Foreign key → User.member_id — NOT NULL
  • loginTime (Field) — date — NOT NULL

Results

  • results_id (Key) — varchar — Primary key — NOT NULL
  • content_id (Key4) — varchar — Foreign key → Contents.content_id — NOT NULL
  • result (Field3) — varchar(20) — NOT NULL
  • title (Field) — varchar(100) — NOT NULL
  • content (Field2) — varchar(500) — NOT NULL
  • user_id (Key2) — varchar(100) — Foreign key → User.member_id — NOT NULL

Shares

  • share_id (Key) — varchar — Primary key — NOT NULL
  • createdAt (Field) — date — NOT NULL
  • user_id (Key2) — varchar(100) — Foreign key → User.member_id — NOT NULL
  • content_id (Key4) — varchar(500) — Foreign key → Contents.content_id — NOT NULL

User

  • member_id (Key) — varchar — Primary key — NOT NULL
  • kakaoId (Field2) — varchar — NOT NULL
  • thumbnail (Field6) — varchar — NOT NULL
  • name (Field3) — varchar — NOT NULL
  • createdAt (Field) — date — NOT NULL
  • password (Field5) — varchar — NOT NULL
  • role (Field4) — varchar — NOT NULL

UserResults (MemberResults)

  • user_results_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — varchar — Foreign key → User.member_id — NOT NULL
  • results_id (Key3) — varchar — Foreign key → Results.results_id — NOT NULL
  • content_id (Key4) — varchar — Foreign key → Results.content_id — NOT NULL
  • createdAt (Field) — date — NOT NULL