Devcourse project 2

Tables (7)

comments

  • id — uuid — Primary key — NOT NULL
  • post_id — uuid — NOT NULL

commnet_likes

  • id — uuid — Primary key — NOT NULL
  • comment_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL

files

  • id — uuid — Primary key — NOT NULL
  • post_id — uuid — NOT NULL

point_logs

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — NOT NULL

post__likes

  • id — uuid — Primary key — NOT NULL
  • post_id — uuid — NOT NULL
  • user_id — uuid — NOT NULL

posts

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — NOT NULL

users

  • id — uuid — Primary key — NOT NULL
  • role — varchar(20) — NOT NULL
  • username — varchar(20) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(100) — NOT NULL
  • email — varchar(255) — NOT NULL
  • current_point — bigint