srp-board2

Tables (3)

SYS_LEO_BOARD

  • BOARD_SNO (BOARD_NO) — NUMBER(10) — Primary key — NOT NULL
  • TITLE — VARCHAR2(200 CHAR) — NOT NULL
  • CONTENT — CLOB — NOT NULL
  • VIEW_CNT — NUMBER(10) — NOT NULL
  • CREATED_AT — TIMESTAMP(6) — NOT NULL
  • UPDATED_AT — TIMESTAMP(6)
  • UPDATED_BY_EMPLOY_CODE — VARCHAR2(8 CHAR)
  • DEL_YN — CHAR(1 CHAR) — NOT NULL
  • AUTHOR_EMPLOY_CODE — VARCHAR2(8 CHAR) — NOT NULL
  • CATEGORY_ID — NUMBER(5) — Foreign key → SYS_LEO_CATEGORY.CATEGORY_ID — NOT NULL

SYS_LEO_BOARD_CMT

  • CMT_NO — NUMBER(10) — Primary key — NOT NULL
  • CONTENT — VARCHAR2(1000 CHAR) — NOT NULL
  • CREATED_AT — TIMESTAMP(6) — NOT NULL
  • UPDATED_AT — TIMESTAMP(6)
  • UPDATED_BY_EMPLOY_CODE — VARCHAR2(8 CHAR)
  • DEL_YN — CHAR(1 CHAR) — NOT NULL
  • AUTHOR_EMPLOY_CODE — VARCHAR2(8 CHAR) — NOT NULL
  • DEPTH — NUMBER(1) — NOT NULL
  • BOARD_NO — NUMBER(10) — Foreign key → SYS_LEO_BOARD.BOARD_SNO — NOT NULL
  • PARENT_CMT_NO — NUMBER(10) — Foreign key → SYS_LEO_BOARD_CMT.CMT_NO

SYS_LEO_CATEGORY

  • CATEGORY_ID — NUMBER(5) — Primary key — NOT NULL
  • CATEGORY_NAME — VARCHAR2(50 CHAR) — NOT NULL