hyowon-note
Tables (4)
CODE_GROUP (COMMON_CODE)
- GROUP_CODE — VARCHAR(100) — Primary key — NOT NULL — THE CODE THAT HAVES OTHER CODES AS ELEMENTS
- ELEMENT_CODE — VARCHAR(100) — Primary key — NOT NULL — THE CODE THAT BELONGS TO GROUP_CODE, VALUE ITSELF
- CODE_MEANING — VARCHAR(100) — NOT NULL — WHAT ELEMENT_CODE STANDS FOR
- CODE_DESC — VARCHAR(300) — NOT NULL — THE MEANING OF THE ELEMENT CODE
- WHERE_USED — CHAR(1) — NOT NULL — WHAT PLACE USES THIS TERM. LIKE TABLE, COLUMN, METHOD, CLASS , ETC
- STATUS — CHAR(1) — NOT NULL — TO MAP WITH STATUS TABLE
- FIRST_REG_DATETIME — CHAR(14) — NOT NULL — REGISTRATION DATETIME OF CREATION
- LAST_UPD_DATETIME — CHAR(14) — NOT NULL — REGISTRATION DATETIME OF LAST UPADTE
- FIRST_REG_IP — VARCHAR(50) — NOT NULL — CREATION IP
- LAST_UPD_IP — VARCHAR(50) — NOT NULL — UPDATE IP
POST
- POST_NO — INT — Primary key — NOT NULL — NUMBER OF THE POST
- AUTHOR — VARCHAR(100) — NOT NULL — WHO WRITES THE POST
- VIEW_CNT — INT — NOT NULL — HOW MANY TIMES THE POST IS READ
- CATEGORY_NO — INT — NOT NULL — CATEGORY NUMBER TO MAP WITH CATEGORY TABLE
- TITLE — VARCHAR(300) — NOT NULL — TITLE OF THE POST
- CONTENT — MEDIUMTEXT — NOT NULL — CONTENT OF THE POST
- STATUS — CHAR(1) — NOT NULL — TO MAP WITH STATUS TABLE
- FIRST_REG_DATETIME — CHAR(14) — NOT NULL — REGISTRATION DATETIME OF CREATION
- LAST_UPD_DATETIME — CHAR(14) — NOT NULL — REGISTRATION DATETIME OF LAST UPADTE
- FIRST_REG_IP — VARCHAR(50) — NOT NULL — CREATION IP
- LAST_UPD_IP — VARCHAR(50) — NOT NULL — UPDATE IP
TERM_DICTIONARY
- TERM_NO — INT — Primary key — NOT NULL — NUMBER OF THE TERM
- TERM — VARCHAR(100) — NOT NULL — TERMINOLOGY
- TERM_DESC — VARCHAR(300) — NOT NULL — DESCRIPTION OF THE TERM
- WHERE_USED — CHAR(1) — NOT NULL — WHAT PLACE USES THIS TERM. LIKE TABLE, COLUMN, METHOD, CLASS , ETC
- STATUS — CHAR(1) — NOT NULL — TO MAP WITH STATUS TABLE
- FIRST_REG_DATETIME — CHAR(14) — NOT NULL — REGISTRATION DATETIME OF CREATION
- LAST_UPD_DATETIME — CHAR(14) — NOT NULL — REGISTRATION DATETIME OF LAST UPADTE
- FIRST_REG_IP — VARCHAR(50) — NOT NULL — CREATION IP
- LAST_UPD_IP — VARCHAR(50) — NOT NULL — UPDATE IP
WORD_DICTIONARY
- WORD_NO (POST_NO) — INT — Primary key — NOT NULL — NUMBER OF THE WORD
- WORD — VARCHAR(50) — NOT NULL — WORD
- WORD_DESC — VARCHAR(300) — NOT NULL — DESCRIPTION ABOUT THE WORD
- DOMAIN_YN — CHAR(1) — NOT NULL — Y : THE WORD USED AS A DOMAIN, N : GENERAL WORD
- DOMAIN_NO — INT — TO MAP WITH DOMAIN TABLE
- STATUS — CHAR(1) — NOT NULL — TO MAP WITH STATUS TABLE
- FIRST_REG_DATETIME — CHAR(14) — NOT NULL — REGISTRATION DATETIME OF CREATION
- LAST_UPD_DATETIME — CHAR(14) — NOT NULL — REGISTRATION DATETIME OF LAST UPADTE
- FIRST_REG_IP — VARCHAR(50) — NOT NULL — CREATION IP
- LAST_UPD_IP — VARCHAR(50) — NOT NULL — UPDATE IP