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)