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