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