InnovationCamp

Tables (4)

COMMENT

  • Comment Key (comment_key) — long — Primary key — NOT NULL
  • Post Key (post_key) — long — Foreign key → POST.Post Key — NOT NULL
  • User Key (user_key) — long — Foreign key → USER.User Key — NOT NULL
  • Post Comment (post_comment) — longtext

POST

  • Post Key (post_key) — long — Primary key — NOT NULL
  • User Key (user_key) — long — Foreign key → USER.User Key — NOT NULL
  • Created At (created_at) — datetime
  • Modified At (modified_at) — datetime
  • Title (title) — Text
  • Like Count (like_count) — BIGINT(20)
  • Comment Count (comment_count) — BIGINT(20)
  • Image URL (image_url) — VARCHAR(255)
  • Content (content) — longtext

SUBCOMMENT

  • Subcomment Key (subcomment_key) — long — Primary key — NOT NULL
  • User Key (user_key) — long — Foreign key → USER.User Key — NOT NULL
  • Comment Key (comment_key2) — long — Foreign key → COMMENT.Comment Key — NOT NULL
  • Post Key (post_key) — long — Foreign key → COMMENT.Post Key — NOT NULL
  • Subcomment (subcomment) — longtext

USER

  • User Key (user_key) — long — Primary key — NOT NULL
  • User Name (user_name) — String
  • User Id (user_id) — VARCHAR(60)
  • User Password (user_password) — VARCHAR(64)