SSBoard

Tables (4)

Untitled (role)

  • Key (id) — int(10) unsigned — Primary key — NOT NULL
  • Field (name) — varchar(32) — NOT NULL — 등급 이름
  • Field2 (level) — tinyint(4) — NOT NULL — 등급 레벨
  • Field (authority) — varchar(255) — NOT NULL — 등급 요청 권한(Admin 구분용)

Untitled (board)

  • Key (id) — int(10) unsigned — Primary key — NOT NULL
  • Field (url_key) — varchar(64) — NOT NULL — 게시판 URL key
  • Field (name) — varchar(64) — NOT NULL — 게시판 이름
  • Field2 (read_level) — tinyint(4) — NOT NULL — 읽기 최소 레벨
  • Field3 (write_level) — tinyint(4) — NOT NULL — 쓰기 최소 레벨
  • Field (reply_level) — tinyint(4) — NOT NULL — 댓글 최소 레벨
  • Field (notice_board) — boolean — NOT NULL — 공지사항 게시판 여부

Untitled (post)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (writer_id) — int(10) unsigned — Foreign key → users.Key — NOT NULL — 작성자 PK
  • Key (board_id) — int(10) unsigned — Foreign key → Untitled.Key — NOT NULL — 게시판 PK
  • Field (title) — varchar(128) — NOT NULL — 글 제목
  • Field (content) — text — NOT NULL — 글 내용
  • Field (write_date) — timestamp — NOT NULL — 작성일
  • Field (modify_date) — timestamp — 수정일
  • Field (hit) — int(11) — NOT NULL — 조회수

users (user)

  • Key (id) — int(10) unsigned — Primary key — NOT NULL
  • Key (role_id) — int(10) unsigned — Foreign key → Untitled.Key — NOT NULL — 등급 PK
  • Field (user_id) — varchar(32) — NOT NULL — 아이디
  • Field2 (password) — varchar(255) — NOT NULL — 비밀번호
  • Field (nickname) — varchar(32) — NOT NULL — 닉네임
  • Field2 (email) — varchar(128) — NOT NULL — 이메일
  • Field3 (create_date) — timestamp — NOT NULL — 가입일
  • Field (email_checked) — boolean — NOT NULL
  • Field4 (blocked) — boolean — NOT NULL — 차단 여부