UDA_SYSTEM
Tables (7)
comm_code (공통코드)
- COM_CD_ID (공통코드ID) — varchar(10) — Primary key — NOT NULL
- COM_CD (코드) — varchar(1)
- COM_CD_NM (코드명) — varchar(100)
- COM_CD_EN (영문코드명) — varchar(10)
- SORT_SN (순번) — int(11)
- CODE_OPTION_NAME (옵션명) — varchar(100)
- CODE_OPTION_VALUE (옵션값) — varchar(100)
- VBG_CRE_USER (등록자) — varchar(50)
- VBG_CRE_DTM (등록일) — datetime
file_info (업로드파일정보)
- id (파일ID) — bigint(20) — Primary key — NOT NULL
- group_id (그룹ID) — bigint(20)
- original_file_name (원본파일명) — varchar(255)
- stored_file_name (암호화파일명) — varchar(255)
- stored_file_path (파일경로) — varchar(255)
- file_sized (파일사이즈) — bigint(20)
- create_at (등록일) — datetime(6)
- del_yn (삭제유무) — varchar(1)
refresh_token_store (리프레쉬토큰저장소)
- USER_ID (유저ID) — varchar(30) — Primary key — NOT NULL
- SEQ (시퀀스번호) — int(11) — Foreign key → user_info.SEQ — NOT NULL
- REFRESH_TOKEN (리프레쉬토큰) — varchar(500)
- EXPIRY_DATE (저장날짜) — datetime
std_field (컬럼관리)
- TABLE_SEQ (1) — int(11) — Primary key — NOT NULL
- TABLE_SEQ (12) — int(11) — Foreign key → std_main.TABLE_SEQ — NOT NULL
- COL_ID (2) — varchar(10)
- COL_NAME (3) — varchar(100)
- COL_TYPE (4) — varchar(1)
- COL_SIZE (5) — int(11)
- COL_IDX (6) — varchar(1)
- COL_SCH (7) — varchar(1)
- VBG_CRE_USER (등록자) — varchar(50)
- VBG_CRE_DTM (등록일) — date
std_header (헤더관리)
- TABLE_SEQ (1) — int(11) — Primary key — NOT NULL
- TABLE_SEQ (12) — int(11) — Foreign key → std_main.TABLE_SEQ — NOT NULL
- HEADER_ID (2) — varchar(10)
- HEADER_NAME (3) — varchar(10)
- SUPI_HEADER (4) — varchar(10)
- HEADER_WIDTH (5) — int(11)
- CONN_FIELD (6) — varchar(10)
- SORT_SN (7) — int(11)
std_main (UDA목록)
- TABLE_SEQ (1) — int(11) — Primary key — NOT NULL
- TABLE_NAME (2) — varchar(100)
- TABLE_ID (3) — varchar(10)
- VBG_CRE_USER (등록자) — varchar(50)
- VBG_CRE_DTM (등록일) — date
user_info (회원정보)
- SEQ (시퀀스번호) — int(11) — Primary key — NOT NULL
- ID — varchar(30)
- PASSWORD (비밀번호) — varchar(100)
- NAME (이름) — varchar(30)
- EMAIL (이메일) — varchar(50)
- ROLE (권한) — varchar(20)