Spring-Board
Tables (4)
Category (카테고리)
- category_id (카테고리 ID) — NOT NULL — Primary key — NOT NULL
- category_type (카테고리 타입) — NOT NULL
- created_at (생성 시간) — NOT NULL
- updated_at (수정 시간) — NOT NULL
Comment (댓글)
- comment_id (댓글 ID) — NOT NULL — Primary key — NOT NULL
- content (내용) — NOT NULL
- member_id (회원 ID) — NOT NULL — Foreign key → Member.member_id — NOT NULL
- post_id (게시글 ID) — NOT NULL — Foreign key → Post.post_id — NOT NULL
- parent_id (부모 댓글 ID) — NOT NULL — Foreign key → Comment.comment_id — NOT NULL
- created_at (생성 시간) — NOT NULL
- updated_at (수정 시간) — NOT NULL
Member (회원)
- member_id (회원 ID) — NOT NULL — Primary key — NOT NULL
- login_id (로그인 ID) — NOT NULL
- nickname (닉네임) — NOT NULL
- created_at (생성 시간) — NOT NULL
- updated_at (수정 시간) — NOT NULL
Post (게시글)
- post_id (게시글 ID) — NOT NULL — Primary key — NOT NULL
- title (제목) — NOT NULL
- content (내용) — NOT NULL
- view_count (조회수) — NOT NULL
- category_id (카테고리 ID) — NOT NULL — Foreign key → Category.category_id — NOT NULL
- member_id (회원 ID) — NOT NULL — Foreign key → Member.member_id — NOT NULL
- created_at (생성 시간) — NOT NULL
- updated_at (수정 시간) — NOT NULL