ss3
Tables (3)
STD_CODE_REF
- COMP_ID — varchar(20) — Primary key — NOT NULL
- ref_code — varchar(20) — Primary key — NOT NULL
- COMP_ID (COMP_ID2) — varchar(20) — Foreign key → STD_COMP_ID.COMP_ID — NOT NULL
- ref_name — varchar(30) — NOT NULL
- S_WORK_TP — varchar(10) — NOT NULL
- system_yn — char(1) — NOT NULL
- code_len — int — NOT NULL
- default_valuecd — varchar(20)
- remarks — varchar(100) — NOT NULL
- input_dt — datetime
- input_id — varchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
STD_CODE_REF_VALUE
- COMP_ID — varchar(20) — Primary key — NOT NULL
- ref_code — varchar(20) — Primary key — NOT NULL
- value_code — varchar(20) — Primary key — NOT NULL
- COMP_ID (COMP_ID2) — varchar(20) — Foreign key → STD_COMP_ID.COMP_ID — NOT NULL
- ref_code (ref_code2) — varchar(20) — Foreign key → STD_CODE_REF.ref_code — NOT NULL
- sortseq — int
- value_name — varchar(100) — NOT NULL
- value_1 — varchar(4000) — NOT NULL
- value_2 — varchar(4000) — NOT NULL
- value_3 — varchar(4000) — NOT NULL
- use_yn — char(1) — NOT NULL
- remarks — varchar(100) — NOT NULL
- input_dt — datetime
- input_id — varchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
STD_COMP_ID
- COMP_ID — varchar(20) — Primary key — NOT NULL
- COMP_NM — varchar(20) — NOT NULL
- COMP_SYSTEM_NM — varchar(50) — NOT NULL
- ERP_IP — varchar(20) — NOT NULL
- use_YN — char(1) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =