dummy

Tables (4)

Category (카테고리)

  • category_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(255)

Comment (댓글)

  • comment_id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL
  • content (Field) — text

Member (유저)

  • member_id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(255)
  • password (Field2) — varchar(255)
  • birth (Field3) — datetime

Post (게시물)

  • post_id (Key) — bigint — Primary key — NOT NULL
  • comment_id (Key3) — bigint — Foreign key → Comment.comment_id — NOT NULL
  • member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL
  • category_id (Key4) — bigint — Foreign key → Category.category_id — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2) — text