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