multiboard_example

Tables (10)

authorities

  • username — varchar2(50) — Primary key — NOT NULL
  • authority — varchar2(50) — NOT NULL

persistent_logins

  • username — varchar(64) — Primary key — NOT NULL
  • series — varchar(64)
  • token — varchar(64) — NOT NULL
  • last_used — timestamp — NOT NULL

tbl_attach

  • uuid — varchar2(100) — Primary key — NOT NULL
  • uploadPath — varchar2(200) — NOT NULL
  • fileName — varchar2(100) — NOT NULL
  • filetype — char(1)
  • bno — number(10,0)

tbl_board

  • bno — number(10,0) — Primary key — 게시글번호
  • title — varchar2(200) — NOT NULL — 제목
  • content — varchar2(2000) — NOT NULL — 내용
  • writer — varchar2(50) — NOT NULL — 작성자
  • regdate — date — 등록일자
  • updater — varchar2(50) — 업데이트자
  • updatedate — date — 업데이트 일자
  • etc1 — 기타1
  • etc2 — 기타2
  • etc3 — 기타3

tbl_board_master (CopyOftbl_board)

  • gcode — number(10,0) — Primary key — 게시판번호
  • depth — varchar2(200) — NOT NULL — 댑스번호
  • gtitle — varchar2(2000) — NOT NULL — 게시판이름
  • etc1 — varchar2(200) — 기타1
  • etc2 — varchar2(200) — 기타2
  • etc3 — varchar2(200) — 기타3
  • writer — varchar2(50) — 작성자
  • regdate — date — 등록일자
  • updater — varchar2(50) — 업데이트자
  • updatedate — date — 업데이트 일자

tbl_member

  • userid — varchar2(50) — Primary key — NOT NULL
  • userpw — varchar2(100) — NOT NULL
  • username — varchar2(100) — NOT NULL
  • regdate — date
  • updatedate — date
  • enabled

tbl_member_auth

  • userid — varchar2(50) — Primary key — NOT NULL
  • auth — varchar2(50) — NOT NULL

tbl_reply

  • rno — number(10,0) — Primary key
  • bno (bno2) — number(10,0) — Foreign key → tbl_board.bno
  • bno — number(10,0) — NOT NULL
  • reply — varchar2(1000) — NOT NULL
  • replyer — varchar2(50) — NOT NULL
  • replyDate — date
  • updateDate — date

user

  • id — bigint(20) — Primary key — NOT NULL
  • avatar_id — bigint(20) — NOT NULL
  • person_id — bigint(20) — NOT NULL
  • version — bigint(20) — NOT NULL
  • account_expired — bit(1) — NOT NULL
  • account_locked — bit(1) — NOT NULL
  • Field

users

  • username — varchar2(50) — Primary key — NOT NULL
  • password — varchar2(50) — NOT NULL
  • enabled — char(1)