nothing
Tables (24)
TX_AIS_INFO (Untitled10)
- Key (MMSI) — VARCHAR — Primary key — NOT NULL
- Key (LAST_LOCATION_ID) — DECIMAL — Foreign key → TX_LOCATION.Key — NOT NULL
- - (VESSEL_NM) — VARCHAR
- - (IMO_NO) — VARCHAR
- - (CALL_SIGN) — VARCHAR
- - (COURSE) — FLOAT
- 위도 (LATITUDE) — FLOAT
- 경도 (LONGITUDE) — FLOAT
- 이동 속도 (SPEED) — FLOAT
- - (HEADING) — INT
- - (TURN) — FLOAT
- - (NAV_CODE) — INT
- - (DESTINATION) — VARCHAR
- - (ATA) — DATETIME
- - (ATD) — DATETIME
- 위치 보고 시간 (RECV_DTM) — DATETIME
- - (VOY_RECV_DTM) — DATETIME
- - (REG_DTM) — DATETIME
TX_AIS_PORTCALL_LOG (선박운항로그)
- Key (PORTCALL_LOG_ID) — DECIMAL — Primary key — NOT NULL
- Key (LOCATION_ID) — DECIMAL — Foreign key → TX_LOCATION.Key — NOT NULL
- - (MMSI) — VARCHAR
- - (ESTIMATE_YN) — INT
- 실제도착시간 (ATA) — DATETIME
- 실제출발시간 (ATD) — DATETIME
- 위도 (LATITUDE) — FLOAT
- 경도 (LONGITUDE) — FLOAT
- 등록일 (REG_DTM) — DATETIME
TX_AIS_USER_CARGO_TRACK_MST (선적추적 마스터)
- 마스터 ID (TRACK_MST_ID) — BINARY — Primary key — NOT NULL
- 선사 코드 (LINE_CD) — VARCHAR — Foreign key → TX_OCEAN_LINE.선사 코드 — NOT NULL
- Key (TRACKING_ID) — DECIMAL — Foreign key → TX_TRACKING.Key — NOT NULL
- 유저 ID (USER_ID) — DECIMAL
- (CONTRACT_SEQ) — DECIMAL
- 수/출입 타입 (IMEX_TP) — NVARCHAR
- 컨테이너 번호 (CNTR_NO) — NVARCHAR
- B/L 번호 (BL_NO) — NVARCHAR
- 배송 타입(DIRECT||T/S) (TRANS_TP) — NVARCHAR
- Field (CUST_ORDER_ID) — NVARCHAR
- 고객사 이름 (CUST_CORP_NM) — NVARCHAR
- 고객 이름 (CUST_NM) — NVARCHAR
- - (ACTIVE_STATUS) — NVARCHAR
- - (NOTICE_ENTER_PORT_YN) — NVARCHAR
- - (NOTICE_IN_FLIGHT_YN) — NVARCHAR
- - (NOTICE_LEAVE_PORT_YN) — NVARCHAR
- 화면표시여부 (DISPLAY_YN) — NVARCHAR
- 트래킹 상태 (TRACK_STATUS) — NVARCHAR
- - (TRACK_DTM) — DATETIME
- 생성날짜 (INS_DTM) — DATETIME
- 생성자 (INS_USER_ID) — DECIMAL
- 수정날짜 (UPD_DTM) — DATETIME
- 수정자 (UPD_USER_ID) — DECIMAL
- MMSI — NVARCHAR
- - (ADMIN_DISPLAY_YN) — NVARCHAR
- - (TRACK_UPD_USER_ID) — DECIMAL
TX_AIS_USER_CARGO_TRACK_SUB (사용자 트래킹 정보)
- 서브 ID (TRACK_SUB_ID) — BINARY — Primary key — NOT NULL
- 마스터 ID (TRACK_MST_ID) — BINARY — Foreign key → TX_AIS_USER_CARGO_TRACK_MST.마스터 ID — NOT NULL
- 베슬 ID (VESSEL_ID) — DECIMAL — Foreign key → TX_VESSEL.베슬 ID — NOT NULL
- 출발지 지역 ID (DEP_LOCATION_ID) — DECIMAL — Foreign key → TX_LOCATION.Key — NOT NULL
- 도착지 지역 ID (ARR_LOCATION_ID) — DECIMAL — Foreign key → TX_LOCATION.Key — NOT NULL
- 유저 ID (USER_ID) — DECIMAL
- 출발 예정 시간 (ETD) — DATETIME
- 도착 예정 시간 (ETA) — DATETIME
- 생성날짜 (INS_DTM) — DATETIME
- 생성자 (INS_USER_ID) — DECIMAL
- 수정날짜 (UPD_DTM) — DATETIME
- 수정자 (UPD_USER_ID) — DECIMAL
- - (INIT_ETD) — VARCHAR
- - (INIT_ETA) — VARCHAR
TX_AIS_USER_VESSEL_TRACK (Untitled3)
- Key (VESSEL_TRACK_ID) — UUID — Primary key — NOT NULL
- 베슬 ID (VESSEL_ID) — DECIMAL — Foreign key → TX_VESSEL.베슬 ID — NOT NULL
- 사용자 ID (USER_ID)
- - (ACTIVE_STATUS)
- 입항알림여부 (NOTICE_ENTER_PORT_YN)
- - (NOTICE_IN_FLIGHT_YN)
- 출항알림여부 (NOTICE_LEAVE_PORT_YN)
- 화면표시여부 (DISP_YN)
- Field (CONTRACT_SEQ)
- 생성일 (INS_DTM)
- 생성자 (INS_USER_ID)
- 수정일 (UPD_DTM)
- 수정자 (UPD_USER_ID)
TX_API_TOKEN (API_토큰_마스터)
- - (TOKEN_VALUE) — UUID — Primary key — NOT NULL
- - (USER_ID) — DECIMAL
- - (STATUS) — VARCHAR
- - (ACTIVE_START_DATE) — DATETIME
- - (ACTIVE_END_DATE) — DATETIME
- - (LIMIT_STATUS) — VARCHAR
- - (DAY_LIMIT_ACC_CNT) — DECIMAL
- - (MON_LIMIT_ACC_CNT) — DECIMAL
- - (TOTAL_LIMIT_ACC_CNT) — DECIMAL
- 생성일 (INS_DTM) — DATETIME
- 생성자 (INS_USER_ID) — DECIMAL
- 수정일 (UPD_DTM) — DATETIME
- 수정자 (UPD_USER_ID) — DECIMAL
TX_API_TOKEN_INFO (API_토큰_서브)
- - (ID) — DECIMAL — Primary key — NOT NULL
- - (TOKEN_VALUE) — UUID — Foreign key → TX_API_TOKEN.- — NOT NULL
- - (IP) — VARCHAR
- - (DOMAIN) — VARCHAR
- - (API_VERSION) — VARCHAR
- 생성일 (INS_DTM) — DATETIME
- 생성자 (INS_USER_ID) — DECIMAL
- 수정일 (UPD_DTM) — DATETIME
- 수정자 (UPD_USER_ID)
TX_CNTNT_COUNTRY (대륙/국가)
- Key (COUNTRY_CODE) — VARCHAR — Primary key — NOT NULL
- - (COUNTRY_NAME) — VARCHAR
- - (COUNTRY_PART) — VARCHAR
- - (CONTINENT) — VARCHAR
- - (USE_YN) — VARCHAR
- - (COUNTRY_NAME_KR) — VARCHAR
- - (LATITUDE) — FLOAT
- - (LONGITUDE) — FLOAT
TX_CRAWLER_JOB_MSG_TEMPLATE (Untitled)
- Key (MSG_SEQ) — Primary key — NOT NULL
- 선사코드 (MSG_LINE_CD)
- - (MSG_TEMPLATE)
- - (USE_YN)
- - (INS_DTM)
- - (INS_USER)
TX_LOCATION (지역(항구))
- Key (LOCATION_ID) — DECIMAL — Primary key — NOT NULL
- Key (CNTRY_CD) — VARCHAR — Foreign key → TX_CNTNT_COUNTRY.Key — NOT NULL
- - (TYPE_CD) — DECIMAL
- - (LOCATION_CD) — VARCHAR
- - (NAME) — VARCHAR
- - (UN_CD) — VARCHAR
- - (LATITUDE) — FLOAT
- - (LONGITUDE) — FLOAT
- - (TIME_ZONE) — FLOAT
- - (NAME_KR) — VARCHAR
TX_OCEAN_LINE (선사)
- 선사 코드 (LINE_CD) — VARCHAR — Primary key — NOT NULL
- - (LINE_NM) — VARCHAR
- - (LINE_NM2) — VARCHAR
- - (LINE_NM_KR) — VARCHAR
- - (CNTRY_CD) — VARCHAR
- - (ALLIANCE) — VARCHAR
- - (CORP_ID) — DECIMAL
- - (LINE_PLAN_URL) — VARCHAR
- - (LINE_SEARCH_URL) — VARCHAR
TX_PORT_GROUP_MST (-)
- Key (GROUP_ID) — Primary key — NOT NULL
- - (GROUP_REPRE_LOCATION_ID)
- - (GROUP_NAME)
- - (GROUP_DESC)
- - (INS_DTM)
- - (INS_USER_ID)
- - (UPD_DTM)
- - (UPD_USER_ID)
TX_PORT_GROUP_SUB (Untitled2)
- - (LOCATION_ID) — Primary key — NOT NULL
- Key (GROUP_ID) — Foreign key → TX_PORT_GROUP_MST.Key — NOT NULL
- - (INS_DTM)
- - (INS_USER_ID)
- - (UPD_DTM)
- - (UPD_USER_ID)
TX_ROLE (권한)
- Key (ROLE_ID) — DECIMAL — Primary key — NOT NULL
- Field (TYPE_CD) — VARCHAR
- Field (ROLE_NAME) — VARCHAR
- Field (DEL_YN) — DECIMAL
- Field (INS_DTM) — DATETIME
- Field (INS_USER_ID) — DECIMAL
- Field (DEL_DTM) — DATETIME
- Field (DEL_USER_ID) — DECIMAL
TX_TERM (이용약관)
- Key (TERM_ID) — DECIMAL — Primary key — NOT NULL
- Field (TERM_TP) — DECIMAL
- Field (TERM_NM) — VARCHAR
- Field (MANDATORY_YN) — DECIMAL
- Field (APPLY_YN) — DECIMAL
- Field (NOTICE_DTM) — DATETIME
- Field (HTML_FILE_NM) — VARCHAR
TX_TRACKING (자동 트래킹 정보)
- Key (TRACKING_ID) — DECIMAL — Primary key — NOT NULL
- 선사 코드 (LINE_CD) — VARCHAR
- B/L 번호 (BL_NO) — VARCHAR
- 컨테이너 번호 (CNTR_NO) — VARCHAR
- Field (TRANS_TP) — VARCHAR
- 베슬 ID (VESSEL_ID) — DECIMAL
- 베슬 이름 (VESSEL_NM) — VARCHAR
- - (VOYAGE) — VARCHAR
- 선적항 (POL) — VARCHAR
- 선적항 ID (POL_ID) — DECIMAL
- 도착항 (POD) — VARCHAR
- 도착항 ID (POD_ID) — DECIMAL
- 선적항 예상출발시간 (POL_ETD) — VARCHAR
- 도착항 예상도착시간 (POL_ETA) — VARCHAR
- 상태 (STATUS) — VARCHAR
- - (TRACK_DTM) — DATETIME
- 수정자 ID (UPD_USER_ID) — DECIMAL
- 수정시간 (UPD_DTM) — DATETIME
TX_TRACKING_CNTR (Untitled5)
- Key (TRACKING_CNTR_ID) — DECIMAL — Primary key — NOT NULL
- Key (TRACKING_ID) — DECIMAL — Foreign key → TX_TRACKING.Key — NOT NULL
- Field (CNTR_NO) — VARCHAR
- Field (CNTR_SZ) — VARCHAR
- Field (CNTR_TP) — VARCHAR
- Field (SEAL_NO) — VARCHAR
TX_TRACKING_VSL (선박 트래킹)
- Key (TRACKING_VSL_ID) — DECIMAL — Primary key — NOT NULL
- Key (TRACKING_ID) — DECIMAL — Foreign key → TX_TRACKING.Key — NOT NULL
- Key (POL_ID) — DECIMAL — Foreign key → TX_LOCATION.Key — NOT NULL
- Key (POD_ID) — DECIMAL — Foreign key → TX_LOCATION.Key — NOT NULL
- Key (VESSEL_ID) — DECIMAL — Foreign key → TX_VESSEL.베슬 ID — NOT NULL
- 선박이름 (VESSEL_NM) — VARCHAR
- 선적항 이름 (POL) — VARCHAR
- 출발예정시간 (ETD) — VARCHAR
- 실제출발시간 (ATD) — VARCHAR
- 하역항 이름 (POD) — VARCHAR
- 도착예상시간 (ETA) — VARCHAR
- 실제도착시간 (ATA) — VARCHAR
- - (INIT_ETD) — VARCHAR
- - (INIT_ETA) — VARCHAR
- - (INIT_DTM) — DATETIME
TX_USER (사용자)
- Key (USER_ID) — DECIMAL — Primary key — NOT NULL
- Field (EMAIL) — VARCHAR
- Field2 (PASSWORD) — VARCHAR
- Field2 (USER_TP) — VARCHAR
- Field2 (JOB_TP) — VARCHAR
- Field2 (JOB_TXT) — VARCHAR
- Field2 (LAST_NM) — VARCHAR
- Field2 (FIRST_NM) — VARCHAR
- Field2 (CMPNY_NM) — VARCHAR
- Field2 (ADDRESS) — VARCHAR
- Field2 (ZIP) — VARCHAR
- Field2 (TEL) — VARCHAR
- Field2 (MOBILE) — VARCHAR
- Field2 (FAX) — VARCHAR
- Field2 (CNTRY_CD) — VARCHAR
- Field2 (CORP_ID) — DECIMAL
- Field2 (STUS_CD) — DECIMAL
- Field2 (REG_DT) — DATETIME
- Field2 (UPD_DT) — DATETIME
- Field2 (LAST_LOGIN_DTM) — DATETIME
TX_USER_AIS_CONTRACT (AIS_계약)
- Key (CONTRACT_SEQ) — DECIMAL — Primary key — NOT NULL
- Key (USER_ID) — DECIMAL — Foreign key → TX_USER.Key — NOT NULL
- Field (CONTRACT_UPPER_SEQ) — DECIMAL
- Field (CONTRACT_TYPE) — VARCHAR
- Field (CONTRACT_UNIT) — VARCHAR
- Field (CONTRACT_UNIT_VAL) — VARCHAR
- Field (CONTRACT_START_DTM) — DATETIME
- Field (CONTRACT_END_DTM) — DATETIME
- Field (CORP_ID) — DECIMAL
- Field (USE_YN) — VARCHAR
- Field (INS_DTM) — DATETIME
- Field (INS_USER_ID) — DECIMAL
- Field (UPD_DTM) — DATETIME
- Field (UPD_USER_ID) — DECIMAL
TX_USER_ROLE (사용자-권한 매핑)
- Key (USER_ROLE_ID) — DECIMAL — Primary key — NOT NULL
- Key (USER_ID) — DECIMAL — Foreign key → TX_USER.Key — NOT NULL
- Key (ROLE_ID) — DECIMAL — Foreign key → TX_ROLE.Key — NOT NULL
- Field (INS_DTM) — DATETIME
- Field (INS_USER_ID) — DECIMAL
- Field (DEL_DTM) — DATETIME
- Field (DEL_USER_ID) — DECIMAL
TX_USER_TERM_AGREEMENT (사용자-이용약관 매핑)
- Key (USER_TERM_AGREEMENT_ID) — DECIMAL — Primary key — NOT NULL
- Key (TERM_ID) — DECIMAL — Foreign key → TX_TERM.Key — NOT NULL
- Key (USER_ID) — DECIMAL — Foreign key → TX_USER.Key — NOT NULL
- Field (AGREE_YN) — DECIMAL
- Field (CONFIRM_DTM) — DATETIME
- Field
TX_VESSEL (베슬)
- 베슬 ID (VESSEL_ID) — DECIMAL — Primary key — NOT NULL
- Key (MMSI) — VARCHAR — Foreign key → TX_AIS_INFO.Key — NOT NULL
- - (VESSEL_NM) — VARCHAR
- - (IMO_NO) — VARCHAR
- - (BUILT_YY) — VARCHAR
- - (CNTRY_CD) — VARCHAR
- - (LENGTH) — FLOAT
- - (WIDTH) — FLOAT
- - (DEPTH) — FLOAT
- - (WATER_LINE) — FLOAT
- - (DWT) — INT
- - (TEU) — INT
- - (PLUG) — INT
- - (SPEED) — FLOAT
- - (OPER_CD) — VARCHAR
- - (CALL_SIGN) — VARCHAR
- - (STUS_CD) — INT
- - (MODIFY_USER) — DECIMAL
- - (MODIFY_DATE) — VARCHAR
- - (GRT) — INT
- - (TEU14TONS) — INT
- - (TYPE_CD) — VARCHAR
- - (TYPE_DESC) — VARCHAR
- - (REMARK) — VARCHAR
TX_VESSEL_SCHEDULE (베슬 스케줄)
- Key (SCH_ID) — DECIMAL — Primary key — NOT NULL
- 베슬 ID (VESSEL_ID) — DECIMAL — Foreign key → TX_VESSEL.베슬 ID — NOT NULL
- - (LOCATION_ID) — DECIMAL — Foreign key → TX_LOCATION.Key — NOT NULL
- 선사 코드 (SHPR_CD) — VARCHAR — Foreign key → TX_OCEAN_LINE.선사 코드 — NOT NULL
- - (VESSEL_NM)
- - (IN_VOYAGE)
- - (OUT_VOYAGE)
- - (PORT_NM)
- - (TMNL_NM)
- - (ARR_DTM)
- - (BERTHN_DTM)
- - (DEP_DTM)
- - (REG_DATE)