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)