CHOIJIWON

Tables (3)

TC_LARGE (대분류)

  • CODE (대분류코드) — VARCHAR2(1) — Primary key — NOT NULL
  • CODE_NM (대분류명) — VARCHAR2(20)
  • STATUS (상태) — VARCHAR2(1)
  • INST_ID (입력자) — VARCHAR2(100)
  • INST_DTM (입력일자) — DATE
  • UPDT_UD (수정자) — VARCHAR2(100)
  • UPDT_DTM (수정일자) — DATE

TC_MEDIUM (중분류)

  • CODE (중분류코드) — VARCHAR2(1) — Primary key — NOT NULL
  • P_CODE (대분류코드) — VARCHAR2(1) — Foreign key → TC_LARGE.CODE — NOT NULL
  • CODE_NM (중분류명) — VARCHAR2(20)
  • STATUS (상태) — VARCHAR2(1)
  • INST_ID (입력자) — VARCHAR2(100)
  • INST_DTM (입력일자) — DATE
  • UPDT_UD (수정자) — VARCHAR2(100)
  • UPDT_DTM (수정일자) — DATE

TC_SMALL (소분류)

  • CODE (소분류코드) — VARCHAR2(1) — Primary key — NOT NULL
  • P_CODE (중분류코드) — VARCHAR2(1) — Foreign key → TC_MEDIUM.CODE — NOT NULL
  • CODE_NM (소분류명) — VARCHAR2(20)
  • STATUS (상태) — VARCHAR2(1)
  • INST_ID (입력자) — VARCHAR2(100)
  • INST_DTM (입력일자) — DATE
  • UPDT_UD (수정자) — VARCHAR2(100)
  • UPDT_DTM (수정일자) — DATE