ㄴㄴ

Tables (9)

app_user

  • user_id — INTEGER
  • username — VARCHAR(20) — NOT NULL
  • password — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP

comment

  • comment_id — int
  • content — text — NOT NULL
  • user_id — INT — NOT NULL
  • post_id — INT — NOT NULL

comment_likes

  • like_id — INT
  • user_id — INT — NOT NULL
  • comment_id — INT — NOT NULL

comments

  • comment_id — INTEGER
  • likes — INT — NOT NULL
  • dislikes — INT — NOT NULL
  • user_id — INT — Foreign key → app_user.user_id — NOT NULL
  • post_id — INT — Foreign key → post.post_id — NOT NULL
  • created_at — TIMESTAMP

follow

  • follow_id — INT — NOT NULL
  • following_id — INT — NOT NULL

image

  • img_id — INT
  • img_name — VARCHAR(30)
  • post_id — INT — NOT NULL

post

  • post_id — INTEGER
  • author — INT — Foreign key → app_user.user_id — NOT NULL
  • likes — INT — NOT NULL
  • views — INT — NOT NULL
  • title — VARCHAR(30) — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • created_at — TIMESTAMP

post_likes

  • like_id — INT
  • user_id — INT — NOT NULL
  • post_id — INT — NOT NULL

user

  • user_id — INT
  • name — VARCHAR(10) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(13) — NOT NULL
  • gender — VARCHAR(10)
  • birthday — VARCHAR(20)
  • user_img — VARCHAR(30)