board

Tables (6)

comment_likes

  • like_id — bigint — Primary key — NOT NULL
  • comment_id — bigint

comments

  • comment_id — bigint — Primary key — NOT NULL
  • post_id (post_id2) — bigint — Foreign key → posts.post_id — NOT NULL
  • usr_id — bigint — Foreign key → users.usr_id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • comment_content — varchar(255) — NOT NULL

likes

  • like_id — bigint — Primary key — NOT NULL
  • usr_id — bigint — Foreign key → users.usr_id — NOT NULL
  • dtype — varchar(31) — NOT NULL
  • like_status — varchar(255) — NOT NULL

post_likes

  • like_id — bigint — Primary key — NOT NULL
  • post_id — bigint

posts

  • post_id — bigint — Primary key — NOT NULL
  • usr_id (usr_id2) — bigint — Foreign key → users.usr_id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • post_content — varchar(255) — NOT NULL
  • post_title — varchar(255) — NOT NULL

users

  • usr_id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • usr_age — integer
  • usr_email — varchar(255) — NOT NULL
  • usr_hobby — varchar(255)
  • usr_name — varchar(255) — NOT NULL
  • usr_password — varchar(255) — NOT NULL