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