my-admin-project

Tables (5)

board

  • 게시글번호 (post_id) — number — Primary key — NOT NULL
  • 회원 (user_id) — varchar2(50) — Foreign key → user.회원 — NOT NULL
  • 제목 (title) — varchar2(255) — NOT NULL
  • 작성일 (created_at) — timestamp — NOT NULL
  • 조회수 (view_count) — number — NOT NULL
  • 내용 (content) — clob — NOT NULL

board_like

  • 게시글번호 (post_id) — number — Foreign key → board.게시글번호 — NOT NULL
  • 회원 (user_id) — varchar2(50) — Foreign key → user.회원 — NOT NULL
  • 좋아요 (like_flag) — CHAR(1) — NOT NULL

comment

  • 댓글번호 (comment_id) — number — Primary key — NOT NULL
  • 게시글번호 (post_id) — number — Foreign key → board.게시글번호 — NOT NULL
  • 회원 (user_id) — varchar2(50) — Foreign key → user.회원 — NOT NULL
  • 작성일 (created_at) — timestamp — NOT NULL
  • 내용 (content) — varchar2(255) — NOT NULL
  • 삭제여부 (deleted_flag) — CHAR(1) — NOT NULL
  • 상위댓글번호 (parent_comment_id) — number
  • 댓글레벨 (comment_level) — number — NOT NULL

comment_like

  • 댓글번호 (comment_id) — number — Foreign key → comment.댓글번호 — NOT NULL
  • 회원 (user_id) — varchar2(50) — Foreign key → user.회원 — NOT NULL
  • 좋아요 (like_flag) — CHAR(1) — NOT NULL

user

  • 회원 (user_id) — varchar2(50) — Primary key — NOT NULL
  • 비밀번호 (password_hash) — number — NOT NULL
  • 이름 (user_name) — varchar2(10) — NOT NULL