123

Tables (3)

comment (0)

  • id (댓글생성id) — bigint — Primary key — NOT NULL
  • user_id (계정생성id) — bigint — Foreign key → users.id
  • post_id (게시글생성id) — bigint — Foreign key → post.user_id
  • contents (내용) — varchar(255)
  • username (사용자id) — varchar(255)
  • created_at (생성시간) — datetime

post (1)

  • id (게시글생성id) — bigint — Primary key — NOT NULL
  • user_id (계정생성id) — bigint — Foreign key → users.id
  • title (제목) — varchar(255)
  • contents (내용) — varchar(255)
  • created_at (생성시간) — datetime
  • username (Field2) — varchar(255)

users (2)

  • id (계정생성id) — bigint — Primary key
  • role (권한) — enum
  • username (사용자id) — varchar(255)
  • password (Field3) — varchar(255)