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