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