Java

Tables (3)

tb_comment (댓글)

  • idx (인덱스) — pk,ai — Primary key — NOT NULL
  • post_idx (게시글idx) — fk,ai — Foreign key → tb_post.idx — NOT NULL
  • content (내용) — nn
  • author (글쓴이) — nn
  • Field
  • idx (인덱스2) — pk,ai — Foreign key → tb_user.idx — NOT NULL

tb_post (게시글)

  • idx (인덱스) — pk,ai — Primary key — NOT NULL
  • title (제목) — nn
  • content (내용) — nn
  • author (글쓴이) — fk,nn
  • likes (좋아요)
  • createdDateTime (생성날짜) — nn
  • modifiedDateTime (수정날짜) — nn
  • idx (인덱스2) — pk,ai — Foreign key → tb_user.idx — NOT NULL

tb_user (유저)

  • idx (인덱스) — pk,ai — Primary key — NOT NULL
  • userId (유저 아이디) — nn
  • email (이메일) — nn
  • password (비밀번호) — nn
  • user_role (유저 권한) — nn
  • createdDateTime (생성날짜) — nn
  • modifiedDateTime (수정날짜) — nn