user

Tables (5)

board

  • index — int — Primary key — NOT NULL
  • 작성자 (username) — varchar(255) — Foreign key → users.id — NOT NULL
  • 제목 (title) — varchar(255)
  • 내용 (content) — varchar(255)
  • 파일 이름 (file_name) — varchar(255)
  • 날짜 (date) — datetime
  • 비밀글 (secret) — bool — 0 : 공개글 1 : 비밀글
  • 조회수 (view) — int
  • 좋아요 (good) — int
  • 싫어요 (bad) — int
  • 신고 (report) — bool
  • 수정 (modify) — bool — NOT NULL

comment

  • com_index — int — Primary key — NOT NULL
  • board_index — int — NOT NULL
  • parent_index — int
  • depth — int — NOT NULL
  • username — varchar(255) — NOT NULL
  • content — varchar(255) — NOT NULL
  • date — datetime — NOT NULL
  • secret — bool — NOT NULL
  • edit — bool — NOT NULL

good_bad

  • board_index — int
  • username — varchar(255)
  • good — int
  • bad — int

manage_view

  • board_index — int
  • username — varchar(255)

users

  • id — varchar(255) — Primary key — NOT NULL
  • pw — varchar(255) — NOT NULL
  • username — varchar(255)
  • email — varchar(255) — NOT NULL — 비밀번호 검증용
  • role — int