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