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