ShareImage
Tables (6)
BaseTime (생성/수정)
- created (생성 날짜) — LocalDateTime
- last_modified (수정 날짜) — LocalDateTime
Category (카테고리)
- category_id (PK) — Long — Primary key — NOT NULL
- name (카테고리명) — String
- parent (부모 카테고리) — Long — Foreign key → Category.category_id — NOT NULL
Comment (댓글)
- comment_id (PK) — Long — Primary key — NOT NULL
- content (댓글 내용) — String
- deleted (삭제 여부) — boolean
- parent (부모 댓글 여부) — boolean
- member_id (PK2) — Long — Foreign key → Member.member_id — NOT NULL
- post_id (PK3) — Long — Foreign key → Post.post_id — NOT NULL
Image (이미지)
- image_id (PK) — Long — Primary key — NOT NULL
- origin_name (원본 이름) — String
- unique_name (고유 이름) — String
- post_id (PK2) — Long — Foreign key → Post.post_id — NOT NULL
Member (회원)
- member_id (PK) — Long — Primary key — NOT NULL
- username (사용자 아이디) — String
- password (비밀번호) — String
- email (이메일) — String
- nickname (사용자 닉네임) — String
Post (글)
- post_id (PK) — Long — Primary key — NOT NULL
- title (글 제목) — String
- content (글 내용) — String
- likes (좋아요 수) — int
- member_id (FK) — Long — Foreign key → Member.member_id — NOT NULL
- category_id (PK2) — Long — Foreign key → Category.category_id — NOT NULL