ㅇㅇ

Tables (9)

comment_likes

  • id — bigint
  • comment_id — bigint
  • user_id — bigint

comments

  • id — bigint
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • content — varchar(255) — NOT NULL
  • parent_id — bigint
  • position — int
  • post_id — bigint
  • user_id — bigint

follows

  • id — bigint
  • follower_id — bigint
  • following_id — bigint

password_history

  • id — bigint — NOT NULL
  • password — varchar(255) — NOT NULL
  • sequence — int — NOT NULL
  • user_id — bigint

password_history_seq

  • next_val — bigint

post_likes

  • id — bigint
  • post_id — bigint
  • user_id — bigint

post_member

  • id — bigint
  • post_id — bigint
  • user_id — bigint

posts

  • id — bigint
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • content — varchar(255) — NOT NULL
  • location — enum — NOT NULL
  • max_count — int — NOT NULL
  • status — tinyint — NOT NULL
  • title — varchar(255) — NOT NULL
  • user_id — bigint
  • check — (`status` between 0 and 1)

users

  • id — bigint
  • age — int
  • email — varchar(255) — NOT NULL
  • gender — enum
  • is_exist_user — bit — NOT NULL
  • kakao_id — bigint
  • nickname — varchar(255)
  • password — varchar(255) — NOT NULL
  • profile — varchar(255)
  • role — enum — NOT NULL
  • username — varchar(255)