jhdsa

Tables (6)

comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • creation_time — DATETIME — NOT NULL
  • is_edited — TINYINT(1) — NOT NULL

like

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

post

  • post_id — BIGINT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • title — VARCHAR(26) — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • created — DATETIME — NOT NULL
  • is_edited — TINYINT(1) — NOT NULL

post_image

  • image_id — BIGINT — Primary key — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • pos — INT — NOT NULL
  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL

post_info

  • post_id — BIGINT — Foreign key → post.post_id — NOT NULL
  • view_cnt — INT — NOT NULL
  • likes_cnt — INT — NOT NULL
  • comments_cnt — INT — NOT NULL

user

  • user_id — INT — Primary key — NOT NULL
  • nickname — VARCHAR(10) — NOT NULL
  • email — VARCHAR(320) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • profile_pic — VARCHAR(255)