드론
테이블 (50)
API연계대상
- 기관코드 — VARCHAR(20)
- 연계인증키 — VARCHAR(20)
- F_PRMSN_IP_ADDR — VARCHAR(20)
T_ACDNT_CLSF
- F_ACDNT_CLSF_CD — VARCHAR(10) — 기본 키 — NOT NULL
- F_ACDNT_CLSF_NM — VARCHAR(20)
- F_ACDNT_CLSF_CN — VARCHAR(20)
- F_SORT_NO — INTEGER
T_ACDNT_DCLR
- F_ACDNT_DCLR_SN — INTEGER — 기본 키 — NOT NULL
- F_ACDNT_PLC — VARCHAR(200)
- F_ACDNT_CN — TEXT
- F_ACDNT_YMD — VARCHAR(8)
- F_ACDNT_TM — VARCHAR(20)
- F_ACDNT_SE — VARCHAR(1)
- F_ACDNT_TYPE — VARCHAR(2)
- F_DCL_NM — VARCHAR(50)
- F_TELNO — VARCHAR(30)
- F_DRONE_DCLR_NO — VARCHAR(12)
- F_FBCTN_NO — VARCHAR(50)
- F_DRONE_SE — VARCHAR(1)
- F_DCL_SN — INTEGER
- F_DCL_SE — VARCHAR(1)
- F_HUMAN_DAMAGE_YN — VARCHAR(1) — NOT NULL
- F_POLICE_DCLR_YN — VARCHAR(1) — NOT NULL
- F_ACDNT_CLSF_CD — VARCHAR(10) — 외래 키 → T_ACDNT_CLSF.F_ACDNT_CLSF_CD
- F_FILE_SN — INTEGER
T_ATND
- F_ATND_SN — INTEGER — 기본 키 — NOT NULL
- F_BZENT_SN — INTEGER
- F_BZENT_NM_SN — INTEGER
- F_SE — VARCHAR(1)
- F_USER_AUTHRT_SN — INTEGER — 외래 키
- 출석일시 — DATETIME
- 퇴실일시 — DATETIME
- F_BEACON_SN — INTEGER
T_AUTHRT_GROUP
- F_AUTHRT_CD — VARCHAR(5) — 기본 키 — NOT NULL
- F_AUTHRT_NM — VARCHAR(100) — NOT NULL
- F_EXTRA_AUTH_YN — VARCHAR(1) — NOT NULL
T_BBS
- F_BBS_SN — INTEGER — 기본 키 — NOT NULL
- F_BBS_SE — VARCHAR(1)
- F_BBS_TITLE — VARCHAR(200)
- F_RGTR_SN — INTEGER
- F_USE_YN — VARCHAR(1) — NOT NULL
T_BBS_CN
- F_BBS_CN_SN — INTEGER — 기본 키 — NOT NULL
- F_BBS_SN — INTEGER — 외래 키 → T_BBS.F_BBS_SN
- F_REG_DT — DATETIME — NOT NULL
- F_BBS_CN — LONGTEXT
- F_USE_YN — VARCHAR(1) — NOT NULL
- F_RGTR_SN — INTEGER
- F_FIX_YN — VARCHAR(1) — NOT NULL
- F_BGNG_DT — DATETIME
- F_END_DT — DATETIME
- F_FILE_SN — INTEGER
- F_BBS_FLD — VARCHAR(1)
T_BEACON
- F_BEACON_SN — INTEGER — 기본 키 — NOT NULL
- F_RGTR_SN — INTEGER
- F_MDFR_SN — INTEGER
- F_REG_DT — DATETIME — NOT NULL
- F_MDFCN_DT — DATETIME — NOT NULL
T_BEACON_HSTRY
- F_BEACON_SN — INTEGER — 외래 키 → T_BEACON.F_BEACON_SN
- F_RGTR_SN — INTEGER
- F_REG_DT — DATETIME — NOT NULL
- F_MAC_ADDR — VARCHAR(17)
T_BZENT
- F_BZENT_SN — INTEGER — 기본 키 — NOT NULL
- F_BZENT_DCLR_SN — INTEGER — 외래 키 → T_BZENT_DCLR.F_BZENT_DCLR_SN
- F_BZENT_NM_SN — INTEGER — 외래 키 → T_BZENT_NM.F_BZENT_NM_SN
- F_BRNO — VARCHAR(10)
- F_PNST_CD — VARCHAR(7)
- F_CRNO — VARCHAR(13)
- F_HMPG — VARCHAR(100)
- F_BRDT — VARCHAR(8)
- F_CORP_FNDN_YMD — VARCHAR(8)
T_BZENT_DCLR
- F_BZENT_DCLR_SN — INTEGER — 기본 키 — NOT NULL
- F_DCLR_SE — VARCHAR(1)
- F_BZENT_DCLR_NO — VARCHAR(20)
- F_BZMN_SE — VARCHAR(1)
- F_REALTY_USE_SE — VARCHAR(1)
- F_MAX_TAKEOFF_WEIGHT_SE — VARCHAR(2)
- F_BIZ_SCOPE — VARCHAR(20)
- F_BIZ_SCOPE_DTL — VARCHAR(20)
- F_FXNO — VARCHAR(30)
- F_TELNO — VARCHAR(30)
- F_BZENT_NM — VARCHAR(50)
- F_RPRSV_NM — VARCHAR(50)
- F_CRNO — VARCHAR(13)
- F_ZIP — VARCHAR(6)
- F_ADDR — VARCHAR(200)
- F_CPTL — INTEGER
- F_ETC_ADDR — VARCHAR(200)
- F_REG_DT — DATETIME — NOT NULL
- F_APRV_DT — DATETIME
- F_BRNO — VARCHAR(10)
- F_BRDT — VARCHAR(8)
- F_BOARD_MBR — TEXT
T_BZENT_DRONE_DCLR
- F_BZENT_DRONE_DCLR_SN — INTEGER — 기본 키 — NOT NULL
- F_DRONE_DCLR_SN — INTEGER
- F_BZENT_DCLR_SN — INTEGER — 외래 키 → T_BZENT_DCLR.F_BZENT_DCLR_SN
- F_REG_DT — DATETIME — NOT NULL
- F_APRV_DT — DATETIME
- F_BZENT_SN — INTEGER
- F_DRONE_SN — INTEGER
T_BZENT_EMP
- F_EMP_SN — INTEGER — 기본 키 — NOT NULL
- F_BZENT_SN — INTEGER — 외래 키 → T_BZENT.F_BZENT_SN
- F_CRTFCT_SN — INTEGER — 외래 키
- F_CRTFCT_NO — VARCHAR(10)
- F_FLNM — VARCHAR(50)
- F_BRDT — VARCHAR(8)
- F_JNCMP_YMD — VARCHAR(8)
- F_RSGNTN_YMD — VARCHAR(8)
- F_EMP_SE — VARCHAR(1)
- F_CAREER — VARCHAR(256)
- F_AUTHRT_STTS — VARCHAR(1)
- F_USER_SN — INTEGER — 외래 키
T_BZENT_NM
- F_BZENT_NM_SN — INTEGER — 기본 키 — NOT NULL
- F_BZENT_SN — INTEGER
- F_BZENT_NM — VARCHAR(50)
- F_REG_DT — DATETIME — NOT NULL
T_CD
- F_CD_VL — VARCHAR(20) — 기본 키 — NOT NULL
- F_CD_GROUP — VARCHAR(20) — 외래 키 → T_CD_GROUP.F_CD_GROUP — NOT NULL
- F_CD_NM — VARCHAR(50)
- F_CD_EXPLN — VARCHAR(200)
- F_USE_YN — VARCHAR(1) — NOT NULL
- F_SORT_NO — INTEGER
T_CD_GROUP
- F_CD_GROUP — VARCHAR(20) — 기본 키 — NOT NULL
- F_CD_GROUP_NM — VARCHAR(50)
T_CHCK
- F_CHCK_SN — INTEGER — 기본 키 — NOT NULL
- F_CHCK_YMD — VARCHAR(8)
- F_BZENT_SN — INTEGER
- F_CHCK_RSLT — VARCHAR(1)
- F_CHCK_OPNN — TEXT
- F_CHCK_SE — VARCHAR(1)
- F_SIGN_FILE_SN — INTEGER
- F_CHCK_LIST_SN — INTEGER — 외래 키 → T_CHCK_LIST.F_CHCK_LIST_SN
- F_IDFR_NM — VARCHAR(50)
- F_RGTR_SN — INTEGER
- F_REG_DT — DATETIME — NOT NULL
- F_CHCK_PLC — VARCHAR(200)
- F_IDNTY_DT — DATETIME
- F_IDFR_SE — INTEGER
T_CHCK_ARTCL
- F_CHCK_ARTC_SN — INTEGER — 기본 키 — NOT NULL
- F_CHCK_ARTCL_YN — VARCHAR(1) — NOT NULL
- F_CHCK_CN — TEXT
- F_CHCK_LIST_SN — INTEGER — 외래 키 → T_CHCK_LIST.F_CHCK_LIST_SN
- F_CHCK_NO — VARCHAR(10)
- F_SORT_NO — INTEGER
T_CHCK_LIST
- F_CHCK_LIST_SN — INTEGER — 기본 키 — NOT NULL
- F_REG_DT — DATETIME — NOT NULL
- F_RGTR_SN — INTEGER
- F_BZENT_SE — VARCHAR(1)
T_CHCK_RSLT
- F_CHCK_RSLT_SN — INTEGER — 기본 키 — NOT NULL
- F_CHCK_ARTC_SN — INTEGER — 외래 키 → T_CHCK_ARTCL.F_CHCK_ARTC_SN — NOT NULL
- F_CHCK_SN — INTEGER — 외래 키 → T_CHCK.F_CHCK_SN — NOT NULL
- F_CHCK_RSLT — VARCHAR(1)
T_CHCK_VLTN_ACTN
- F_SORT_NO — INTEGER — 기본 키 — NOT NULL
- F_CHCK_RSLT_SN — INTEGER — 외래 키 → T_CHCK_RSLT.F_CHCK_RSLT_SN — NOT NULL
- F_ACTN_DEADLINE_YMD — VARCHAR(8)
- F_ACTN_RSLT — TEXT
- F_VLTN_SE — VARCHAR(1)
- F_RELATED_BASIS — VARCHAR(100)
- F_VLTN_CN — TEXT
- F_DENIAL_RSN — VARCHAR(200)
- F_ACTN_RSLT_FILE_GROUP_SN — INTEGER
- F_VLTN_BASIS_FILE_GROUP_SN — INTEGER
- F_ACTN_SE — VARCHAR(1)
- F_RGTR_SN — INTEGER
- F_REG_DT — DATETIME — NOT NULL
- F_IDNTY_DT — DATETIME
- F_IDFR_SE — INTEGER
T_CRCLM
- F_CRCLM_SN — INTEGER — 기본 키 — NOT NULL
- F_CRCLM_NM — VARCHAR(100)
- F_DRONE_SE — VARCHAR(1)
T_CRCLM_CAPACITY
- F_WEEKDAY_SE — VARCHAR(1) — 기본 키 — NOT NULL
- F_DRONE_SE — VARCHAR(1) — 기본 키 — NOT NULL
- F_DRONE_CLS — VARCHAR(1) — 기본 키 — NOT NULL
- F_PRO_EDNST_DSGN_SN — INTEGER — 외래 키 — NOT NULL
- F_CAPACITY_TIME — INTEGER
- F_CAPACITY_YEAR — INTEGER
- F_REG_SE — VARCHAR(1)
T_DRONE
- F_DRONE_SN — INTEGER — 기본 키 — NOT NULL
- F_DRONE_SE — VARCHAR(1)
- F_MDL_NM — VARCHAR(50)
- F_MNFCTR — VARCHAR(50)
- F_FBCTN_NO — VARCHAR(50)
- F_FBCTN_YMD — VARCHAR(8)
- F_DRONE_WEIGHT — INTEGER
- F_WEIGHT_SE — VARCHAR(2)
- F_SORT_NO — INTEGER
- F_MAX_TAKEOFF_WEIGHT — INTEGER
- F_DRONE_SZ — VARCHAR(20)
- F_REG_DT — DATETIME — NOT NULL
- F_BATTERY_SPCFCT — VARCHAR(20)
- F_MAX_SPEED — INTEGER
- F_MAX_FLIGHT_TM — INTEGER
- F_LOAD_WEIGHT — INTEGER
- F_VTOL_YN — VARCHAR(1) — NOT NULL
T_DRONE_DCLR
- F_DRONE_DCLR_SN — INTEGER — 기본 키 — NOT NULL
- F_DRONE_DCLR_NO — VARCHAR(12)
- F_DCLR_SE — VARCHAR(1)
- F_BENEFIT_YN — VARCHAR(1) — NOT NULL
- F_EQPMNT_LOAD_CN — VARCHAR(256)
- F_EQPMNT_LOAD_YN — VARCHAR(1) — NOT NULL
- F_INSRNC_JOIN_YN — VARCHAR(1) — NOT NULL
- F_INSRNC_JOIN_CN — VARCHAR(256)
- F_STORAGE_PLC_ZIP — VARCHAR(6)
- F_OWNR_ZIP — VARCHAR(6)
- F_STORAGE_ADDR — VARCHAR(200)
- F_OWNR_ADDR — VARCHAR(200)
- F_TELNO — VARCHAR(30)
- F_OWNR_NM — VARCHAR(50)
- F_MBL_TELNO — VARCHAR(15)
- F_BRDT — VARCHAR(8)
- F_REG_DT — DATETIME — NOT NULL
- F_APRV_DT — DATETIME
- F_DRONE_SN — INTEGER — 외래 키 → T_DRONE.F_DRONE_SN
T_EDNST_CRCLM
- F_BZENT_SN — INTEGER — 외래 키 → T_BZENT.F_BZENT_SN — NOT NULL
- F_CRCLM_SN — INTEGER — 외래 키 → T_CRCLM.F_CRCLM_SN — NOT NULL
T_EDNST_STUDENT
- F_BZENT_SN — INTEGER — 외래 키 → T_BZENT.F_BZENT_SN — NOT NULL
- F_USER_SN — INTEGER — 외래 키 — NOT NULL
- F_REG_DT — DATETIME — NOT NULL
- F_APRV_YN — VARCHAR(1) — NOT NULL
- F_APLY_DT — DATETIME
T_EDU_PLC
- F_EDU_PLC_SN — INTEGER — 기본 키 — NOT NULL
- F_PLC_SE — VARCHAR(1)
- F_PRO_EDNST_DSGN_SN — INTEGER — 외래 키
- F_ZIP — VARCHAR(6)
- F_ADDR — VARCHAR(200)
- F_FILE_SN — INTEGER
- F_FLIGHT_LINE — INTEGER
- F_REG_SE — VARCHAR(1)
T_EDU_PLC_EQPMNT
- F_EQPMNT_SN — INTEGER — 기본 키 — NOT NULL
- F_EDU_PLC_SN — INTEGER — 외래 키 → T_EDU_PLC.F_EDU_PLC_SN
- F_EQPMNT_SE — VARCHAR(2)
- F_EQPMNT_NM — VARCHAR(50)
- F_QNTTY — INTEGER
- F_SORT_NO — INTEGER
- F_FILE_SN — INTEGER
- F_REG_SE — VARCHAR(1)
T_EDU_PLC_FCLT
- F_FCLT_SN — INTEGER — 기본 키 — NOT NULL
- F_FCLT_SE — VARCHAR(2)
- F_EDU_PLC_SN — INTEGER — 외래 키 → T_EDU_PLC.F_EDU_PLC_SN
- F_FCLT_NM — VARCHAR(50)
- F_AREA — INTEGER
- F_SORT_NO — INTEGER
- F_FILE_SN — INTEGER
- F_REG_SE — VARCHAR(1)
T_EDU_SBJCT
- F_SBJCT_SE — VARCHAR(20)
- F_INSTR_EDU_LECTURER_SN — INTEGER — 외래 키 → T_INSTR_EDU_LECTURER.F_INSTR_EDU_LECTURER_SN
- F_INSTR_EDU_CYCL_SN — INTEGER — 외래 키 → T_INSTR_EDU_NO.F_INSTR_EDU_CYCL_SN
T_ENTR_QLFC
- F_ENTR_QLFC_SN — INTEGER — 기본 키 — NOT NULL
- F_USER_SN — INTEGER
- F_FILE_SN — INTEGER
- F_DRONE_SE — VARCHAR(1)
- F_QLFC_SE — VARCHAR(1)
- F_RSN — VARCHAR(250)
- F_STTS — VARCHAR(2)
- F_PRCS_DT — DATETIME
- F_CRTFCT_NO — VARCHAR(10)
- F_TELNO — VARCHAR(30)
- F_MBL_TELNO — VARCHAR(15)
- F_EML — VARCHAR(50)
- F_ACQS_YMD — VARCHAR(8)
- F_BRDT — VARCHAR(8)
- F_FLNM — VARCHAR(50)
- F_TFLIGHT_TIME — INTEGER
- F_APLY_DT — DATETIME
- F_RCPT_DT — DATETIME
- F_RVW_DT — DATETIME
T_FILE
- F_FILE_SN — INTEGER — 기본 키 — NOT NULL
- F_FILE_NM — VARCHAR(200)
- F_FILE_SZ — INTEGER
- F_STRG_FILE_NM — VARCHAR(50)
- F_FILE_PATH — VARCHAR(100) — NOT NULL
- F_FILE_SE — VARCHAR(3)
- F_REG_DT — DATETIME — NOT NULL
- F_DEL_DT — DATETIME
- F_SORT_NO — INTEGER
- F_EXTN_NM — VARCHAR(10)
- F_DEL_YN — VARCHAR(1) — NOT NULL
T_FLIGHT_HSTRY
- F_FLIGHT_HSTRY_SN — INTEGER — 기본 키 — NOT NULL
- F_STUDENT_SN — INTEGER
- F_INSTR_SN — INTEGER
- F_DRONE_SN — INTEGER
- F_FLIGHT_YMD — VARCHAR(8)
- F_BZENT_SN — INTEGER
- F_BGNG_DT — DATETIME
- F_END_DT — DATETIME
- F_FLIGHT_BGNG_DT — DATETIME
- F_FLIGHT_END_DT — DATETIME
- F_FLIGHT_TIME — INTEGER
- F_FLIGHT_LINE — INTEGER
- 비행구분 — VARCHAR(1)
- F_MODULE_SN — INTEGER
T_INSCTR
- F_INSCTR_SN — INTEGER — 기본 키 — NOT NULL
- F_CHCK_SN — INTEGER — 외래 키 → T_CHCK.F_CHCK_SN — NOT NULL
- F_FLNM — VARCHAR(50)
- F_SIGN_FILE_SN — INTEGER
- F_JBTTL_NM — VARCHAR(50)
- F_DEPT_NM — VARCHAR(50)
T_INSRNC_GDS
- F_INSRNC_GDS_SN — INTEGER — 기본 키 — NOT NULL
- F_GDS_CD — VARCHAR(10)
- F_GDS_NM — VARCHAR(50)
- F_INSURER_CD — VARCHAR(5) — 외래 키 → T_INSURER.F_INSURER_CD
- F_REWARD_LIMIT — VARCHAR(20)
- F_COVERAGE — VARCHAR(20)
- F_SP_CTRT — VARCHAR(200)
T_INSRNC_JOIN
- F_INSRNC_JOIN_SN — INTEGER — 기본 키 — NOT NULL
- F_INSURER_CD — VARCHAR(5)
- F_FBCTN_NO — VARCHAR(50)
- F_DRONE_DCLR_NO — VARCHAR(12)
- F_SCRT_NO — VARCHAR(20)
- F_GDS_NM — VARCHAR(50)
- F_GDS_CD — VARCHAR(10)
- F_CTRTR_NM — VARCHAR(50)
- F_INSURANT_NM — VARCHAR(50)
- F_INSURANT_ADDR — VARCHAR(200)
- F_CTRTR_ADDR — VARCHAR(200)
- F_INSURANT_SE — VARCHAR(1)
- F_CTRTR_SE — VARCHAR(1)
- F_BGNG_DT — DATETIME
- F_END_DT — DATETIME
- F_TOTAL_JOIN_AMT — INTEGER
- F_TELNO — VARCHAR(30)
- F_REWARD_LIMIT — VARCHAR(20)
- F_COVERAGE — VARCHAR(20)
- F_JOIN_STTS — VARCHAR(1)
- F_SP_CTRT — VARCHAR(200)
- F_INSRNC_GDS_SN — INTEGER — 외래 키 → T_INSRNC_GDS.F_INSRNC_GDS_SN — NOT NULL
T_INSRNC_REWARD
- F_INSRNC_REWARD_SN — INTEGER — 기본 키 — NOT NULL
- F_REWARD_AMT — INTEGER
- F_ACDNT_PLC — VARCHAR(200)
- F_ACDNT_CN — TEXT
- F_REWARD_YMD — VARCHAR(8)
- F_ACDNT_YMD — VARCHAR(8)
- F_ACDNT_TM — VARCHAR(20)
- F_REWARD_STTS — VARCHAR(2)
- F_INSRNC_JOIN_SN — INTEGER — 외래 키 → T_INSRNC_JOIN.F_INSRNC_JOIN_SN — NOT NULL
T_INSTR_CRCLM
- F_INSTR_CRCLM_SN — INTEGER — 기본 키 — NOT NULL
- F_DRONE_SE — VARCHAR(1)
- F_CRCLM_NM — VARCHAR(100)
- F_EDU_DAY_CNT — INTEGER
- F_FEE — INTEGER
- F_EDU_HR — INTEGER
- F_CAPACITY — INTEGER
- F_EDU_TRGT — VARCHAR(250)
- F_EDU_GOALS — VARCHAR(250)
- F_EDU_OVERVIEW — TEXT
- F_QLFC_SE — VARCHAR(1)
- F_EDU_CN — TEXT
- F_FILE_SN — INTEGER
- F_RMBR_YN — VARCHAR(1) — NOT NULL
- F_ESNTL_YN — VARCHAR(1) — NOT NULL
- F_TRUST_YN — VARCHAR(1) — NOT NULL
T_INSTR_EDU_LECTURER
- F_INSTR_EDU_LECTURER_SN — INTEGER — 기본 키 — NOT NULL
- F_INSTR_NM — VARCHAR(100)
- F_DEL_DT — DATETIME
- F_REG_DT — DATETIME — NOT NULL
- F_RMRK — TEXT
T_INSTR_EDU_NO
- F_INSTR_EDU_CYCL_SN — INTEGER — 기본 키 — NOT NULL
- F_INSTR_CRCLM_SN — INTEGER — 외래 키 → T_INSTR_CRCLM.F_INSTR_CRCLM_SN
- F_YR — VARCHAR(4)
- F_EDU_BGNG_YMD — VARCHAR(8)
- F_EDU_END_YMD — VARCHAR(8)
- F_CAPACITY — INTEGER
- F_CYCL — INTEGER
- F_INSTR_EDU_PLC_SN — INTEGER — 외래 키 → T_INSTR_EDU_PLC.F_INSTR_EDU_PLC_SN
- F_APLY_BGNG_YMD — VARCHAR(8)
- F_APLY_END_YMD — VARCHAR(8)
- F_RTRCN_BGNG_YMD — VARCHAR(8)
- F_RTRCN_END_YMD — VARCHAR(8)
T_INSTR_EDU_PLC
- F_INSTR_EDU_PLC_SN — INTEGER — 기본 키 — NOT NULL
- F_ADDR — VARCHAR(200)
- F_ZIP — VARCHAR(6)
- F_EDU_PLC_NM — VARCHAR(50)
T_INSTR_STUDENT
- F_INSTR_STUDENT_SN — INTEGER — 기본 키 — NOT NULL
- F_INSTR_EDU_CYCL_SN — INTEGER — 외래 키 → T_INSTR_EDU_NO.F_INSTR_EDU_CYCL_SN
- F_APLY_NO — INTEGER
- F_APLY_DT — DATETIME
- F_STUDENT_SN — INTEGER
- 수료등록일시 — DATETIME
- 수료확인일시 — DATETIME
- 입과승인일시 — DATETIME
- 입과확인일시 — DATETIME
- F_ENTR_YMD — VARCHAR(8)
- F_FNSH_YMD — VARCHAR(8)
- F_PASS_YN — VARCHAR(1) — NOT NULL
- F_FNSH_YN — VARCHAR(1) — NOT NULL
- F_STTS — VARCHAR(2)
T_INSURER
- F_INSURER_CD — VARCHAR(5) — 기본 키 — NOT NULL
- F_INSURER_NM — VARCHAR(30)
T_LGN_HSTRY
- F_LGN_SN — INTEGER — 기본 키 — NOT NULL
- F_LGN_DT — DATETIME
- F_USER_SN — INTEGER — 외래 키
- F_LGN_IP_ADDR — VARCHAR(15) — NOT NULL
- F_ACS_MTHD — VARCHAR(1)
- F_LGT_DT — DATETIME
- F_SESSION_ID — VARCHAR(80)
T_MENU
- F_MENU_SN — INTEGER — 기본 키 — NOT NULL
- F_MENU_NM — VARCHAR(50)
- F_MENU_URL — VARCHAR(100)
- F_USE_YN — VARCHAR(1) — NOT NULL
- F_MENU_OPT — VARCHAR(20)
- F_UP_MENU_SN — INTEGER
- F_SORT_NO — INTEGER
T_MENU_AUTHRT
- F_AUTHRT_CD — VARCHAR(5) — 외래 키 → T_AUTHRT_GROUP.F_AUTHRT_CD — NOT NULL
- F_MENU_SN — INTEGER — 외래 키 → T_MENU.F_MENU_SN — NOT NULL
- F_USE_YN — VARCHAR(1) — NOT NULL
T_MENU_USE_HSTRY
- F_MENU_USE_HSTRY_SN — INTEGER — 기본 키 — NOT NULL
- F_MENU_SN — INTEGER — 외래 키 → T_MENU.F_MENU_SN
- F_USER_SN — INTEGER — 외래 키
- F_REG_DT — DATETIME — NOT NULL
- F_MENU_OPT — VARCHAR(20)
- F_RSN — VARCHAR(250)
- F_NOCS — INTEGER
- F_LGN_SN — INTEGER — 외래 키 → T_LGN_HSTRY.F_LGN_SN
T_MNGR
- F_USER_SN — INTEGER — 기본 키 — NOT NULL
- F_ID — VARCHAR(20) — NOT NULL
- F_PSWD — VARCHAR(128)
- F_PSWD_CHG_DT — DATETIME
- F_LAST_LGN_DT — DATETIME
- F_FLNM — VARCHAR(50)
- F_DEPT_NM — VARCHAR(50)
- F_PRMSN_IP_ADDR — VARCHAR(20)
- F_AUTHRT_SE — VARCHAR(1) — NOT NULL
- F_MBL_TELNO — VARCHAR(15)
- F_EML — VARCHAR(50)
- F_TELNO — VARCHAR(30)
- F_JBGD_NM — VARCHAR(50)
- F_USE_YN — VARCHAR(1) — NOT NULL
- F_LGN_FAIL_NMTM — INTEGER
- F_LAST_LGN_FAIL_DT — DATETIME
T_MODULE
- F_MODULE_SN — INTEGER — 기본 키 — NOT NULL
- F_DRONE_SN — INTEGER
- F_BZENT_SN — INTEGER
- F_RGTR_SN — INTEGER
- F_MDFR_SN — INTEGER
- F_REG_DT — DATETIME — NOT NULL
- F_MDFCN_DT — DATETIME — NOT NULL
- F_SN — INTEGER
- 모듈ID — VARCHAR(20)