webprogramming2

Tables (5)

Category (카테고리)

  • id (Key) — Long — Primary key — NOT NULL
  • name (이름) — varchar
  • id (parent_category_id) — Long — Foreign key → Category.id — NOT NULL

Comment (댓글)

  • id (Key) — Long — Primary key — NOT NULL
  • content (내용) — varchar
  • create_at (작성일) — datetime
  • update_at (수정일) — datetime
  • post_id (게시물id) — Long — Foreign key → Post.id — NOT NULL

Like (좋아요)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (사용자id) — Long — Foreign key → User.id — NOT NULL
  • post_id (게시물id) — Long — Foreign key → Post.id — NOT NULL

Post (게시글)

  • id (Key) — Long — Primary key — NOT NULL
  • title (제목) — varchar
  • content (내용) — text
  • create_at (생성일) — datetime
  • update_at (수정일) — datetime
  • views (조회 수) — bigint
  • user_id (작성자id) — Long — Foreign key → User.id — NOT NULL
  • category_id (카테고리id) — Long — Foreign key → Category.id — NOT NULL

User (사용자)

  • id (Key) — Long — Primary key — NOT NULL
  • email (이메일 아이디) — varchar
  • password (비밀번호) — varchar
  • date_of_birth (생년월일) — date
  • nickname (닉네임) — varchar
  • badge_status (뱃지 상태) — boolean
  • admin (관리자 여부) — boolean
  • profile_image (프로필 사진) — varchar