SIm pang V2
Tables (9)
Comments (comments)
- Comment Id (id) — PK_INT — Primary key — NOT NULL
- Parent Comment_id (parent_comment_id) — VARCHAR
- Content (content) — VARCHAR
- Commentable Type (commentable_type) — ENUM('contents')
- Created At (created_at) — TIMESTAMP
- Updated At (updated_at) — TIMESTAMP
- Member Id (member_id) — PK — Foreign key → Members.Member Id — NOT NULL
- Commentable Id (content_id) — PK_INT — Foreign key → Contents.Contents Id — NOT NULL
Contents (contents)
- Contents Id (id) — PK_INT — Primary key — NOT NULL
- TItle (title) — VARCHAR(20)
- Description (description) — VARCHAR(200)
- Questions (questions) — OBJECT
- Results (results) — OBJECT
- Thumbnail Url (thumbnail_url) — VARCHAR
- Like Count (like_count) — INT
- Comment Count (comment_count) — INT
- Play Count (play_count) — INT
- Created At (created_at) — TIMESTAMP
- Updated At (updated_at) — TIMESTAMP
- Member Id (id2) — PK — Foreign key → Members.Member Id — NOT NULL
Likes (likes)
- Key (like_id) — PK_INT — Primary key — NOT NULL
- Likeable Type (likeable_type) — ENUM('contents')
- Created At (created_id) — TIMESTAMP
- Contents Id (id2) — PK_INT — Foreign key → Contents.Contents Id — NOT NULL
- Member Id (id3) — PK — Foreign key → Members.Member Id — NOT NULL
Login History (login_history)
- Login History Id (id) — PK_INT — Primary key — NOT NULL
- Login At (login_at) — TIMESTAMP
- IP Address (ip_address) — VARCHAR
- User Agent (user_agent) — VARCHAR
- Member Id (member_id) — PK — Foreign key → Members.Member Id — NOT NULL
Member Play Results (member_play_results)
- Member Play Result Id (id) — PK_INT — Primary key — NOT NULL
- Result (result) — VARCHAR
- Score (score) — INT
- Completed At (completed_at) — TIMESTAMP
- Member Id (member_id) — PK — Foreign key → Members.Member Id — NOT NULL
- Contents Id (contents_id) — PK_INT — Foreign key → Contents.Contents Id — NOT NULL
Members (members)
- Member Id (id) — PK — Primary key — NOT NULL
- Provider (provider) — VARCHAR — NOT NULL
- Provider Id (provider_id) — INT — NOT NULL
- Provider Access Token (provider_access_token) — VARCHAR
- Email (email) — VARCHAR
- Nickname (nickname) — VARCHAR
- Profile Url (profile_url) — VARCHAR
- Created At (created_at) — TIMESTAMP — NOT NULL
- Last Login (last_login) — TIMESTAMP
- Role (role) — ENUM('admin', 'user', 'creator')
Object Tags (object_tags)
- Object Tag Id (id) — PK — Primary key — NOT NULL
- Taggable Type (taggable_type) — ENUM('contents')
- Created At (created_at) — TIMESTAMP
- Tag Id (tag_id) — PK — Foreign key → Tags.Tag Id — NOT NULL
- Taggable Id (content_id) — PK_INT — Foreign key → Contents.Contents Id — NOT NULL
Shares (shares)
- Share Count Id (id) — PK_INT — Primary key — NOT NULL
- Shared At (shared_at) — TIMESTAMP
- Shareable Type (shareable_type) — ENUM('contents')
- Member Id (member_id) — PK — Foreign key → Members.Member Id — NOT NULL
- Shareable Id (contents_id) — PK_INT — Foreign key → Contents.Contents Id — NOT NULL
Tags (tags)
- Tag Id (id) — PK — Primary key — NOT NULL
- Name (name) — VARCHAR
- Created At (created_at) — TIMESTAMP