srp-board

Tables (3)

CATEGORY (SYS_LEO_CATEGORY)

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

SYS_LEO_BOARD

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

SYS_LEO_BOARD_CMT

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