Clone

Tables (7)

comment

  • id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • post_id — BIGINT — Foreign key → post.id — NOT NULL

commentLike

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • comment_id — BIGINT — Foreign key → comment.id — NOT NULL

follow

  • id — BIGINT — Primary key — NOT NULL
  • from_user_id — BIGINT — Foreign key → user.id — NOT NULL
  • to_user_id — BIGINT — Foreign key → user.id — NOT NULL

post

  • id — BIGINT — Primary key — NOT NULL
  • imageSource — VARCHAR(255) — NOT NULL
  • description — BLOB
  • user_id — BIGINT — Foreign key → user.id — NOT NULL

postLike

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • post_id — BIGINT — Foreign key → post.id — NOT NULL

tag

  • id — BIGINT — Primary key — NOT NULL
  • tagname — VARCHAR(50) — NOT NULL
  • post_id — BIGINT — Foreign key → post.id — NOT NULL

user

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(20) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255)
  • profileImage — VARCHAR(255)
  • createAt — DATETIME — NOT NULL
  • modifiedDate — DATETIME — NOT NULL