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