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