board_example

Tables (11)

Untitled

    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 — 등록일자
    • updatedate — date — 업데이트 일자

    tbl_board (CopyOftbl_board)

    • bno — number(10,0) — Primary key — 게시글번호
    • title — varchar2(200) — NOT NULL — 제목
    • content — varchar2(2000) — NOT NULL — 내용
    • writer — varchar2(50) — NOT NULL — 작성자
    • regdate — date — 등록일자
    • 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)