board
Tables (5)
BOARDLIST (게시판목록)
- LIST_NO (목록번호) — SERIAL — Primary key — NOT NULL
- LIST_NAME (목록이름) — VARCHAR(255)
POST (게시글)
- POST_NO (게시글번호) — SERIAL — Primary key — NOT NULL
- LIST_NO (목록번호) — INTEGER — Foreign key → BOARDLIST.LIST_NO — NOT NULL
- USERNAME (이름) — VARCHAR2(50) — Foreign key → USER.USERNAME
- TITLE (게시글제목) — VARCHAR(255)
- CONTENT (게시글내용) — TEXT
- REGDATE (등록일) — DATE
- READCOUNT (조회수) — INTEGER
- USERNAME (등록자) — VARCHAR2(100)
ROLE (권한)
- ID (Key) — BIGINT — Primary key — NOT NULL
- NAME (이름) — VARCHAR2(50)
USER (사용자)
- USERNAME (이름) — VARCHAR2(255) — Primary key
- PASSWORD (비밀번호) — VARCHAR2(255)
- ENABLED (인증) — CHAR
USER_ROLE (Untitled)
- ID (권한아이디) — BIGINT — Foreign key → ROLE.ID — NOT NULL
- USERNAME (이름) — VARCHAR2(50) — Foreign key → USER.USERNAME