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