board

Tables (3)

Comment (댓글)

  • id (댓글ID) — NOT NULL — Primary key — NOT NULL
  • post_id (게시글ID) — NOT NULL — Foreign key → Post.id — NOT NULL
  • member_id (회원ID) — NOT NULL — Foreign key → Member.id — NOT NULL
  • content (내용) — NOT NULL — NOT NULL
  • created_at (생성일) — NOTNULL
  • modified_at (수정일) — NOTNULL

Member (회원)

  • id (회원ID) — NOT NULL — Primary key — NOT NULL
  • email (이메일) — NOT NULL
  • password (비밀번호) — NOT NULL — NOT NULL
  • name (이름) — NOT NULL
  • nickname (닉네임) — NOT NULL
  • gender (성별) — NOTNULL
  • role (권한) — NOTNULL
  • created_at (생성일) — NOTNULL
  • modified_at (수정일) — NOTNULL

Post (게시글)

  • id (게시글ID) — NOT NULL — Primary key — NOT NULL
  • member_id (회원ID) — NOT NULL — Foreign key → Member.id — NOT NULL
  • title (제목) — NOT NULL
  • content (내용) — NOT NULL — NOT NULL
  • commnets (댓글) — NOT NULL
  • created_at (생성일) — NOTNULL
  • modified_at (수정일) — NOTNULL — NOT NULL