testt
Tables (11)
TB_ACDT (사고이력)
- SHIP_ID (Key) — VARCHAR — Foreign key → TB_SHIP.SHIP_ID — NOT NULL
- COMPANY_ID (Key2) — VARCHAR — Foreign key → TB_SHIP.COMPANY_ID — NOT NULL
- SHIP_RECORD_TIME (Field) — TIMESTAMP
- SHIP_NATION (Field2) — VARCHAR
- ACDT_NM (Field3) — VARCHAR
- ACDT_DESC (Field4) — VARCHAR
- ACDT_GEOM (Field5) — GEOMETRY
- ACDT_DATE (Field6) — TIMESTAMP
TB_AUTH (권한 그룹)
- AUTH_IDX (Key) — NUMBER — Primary key — NOT NULL
- AUTH_LEVEL (Field) — VARCHAR
- AUTH_NM (Field2) — VARCHAR
TB_MESSAGE (메세지/쪽지)
- MSG_ID (Key) — NUMBER — Primary key — NOT NULL
- USID (Key2) — VARCHAR — Foreign key → TB_USER.USID — NOT NULL
- AUTH_IDX (Key22) — NUMBER — Foreign key → TB_USER.AUTH_IDX — NOT NULL
- MSG_RECEIVER (Field2) — VARCHAR
- MSG_DATE (Field5) — TIMESTAMP
- MSG_READ_DATE (Field6) — TIMESTAMP
- READ_FLAG (Field4) — NUMBER
TB_MESSAGE_DESC (메세지 내용)
- MSG_ID (Key) — NUMBER — Foreign key → TB_MESSAGE.MSG_ID — NOT NULL
- USID (Key2) — VARCHAR — Foreign key → TB_MESSAGE.USID — NOT NULL
- AUTH_IDX (Key22) — NUMBER — Foreign key → TB_MESSAGE.AUTH_IDX — NOT NULL
- MSG_DESC (Field) — VARCHAR\
TB_PORT (입/출항 구역)
- PORT_IDX (Key) — NUMBER — Primary key — NOT NULL
- PORT_NM (Field) — VARCHAR
- PORT_GEOM (Field2) — GEOMETRY
TB_SHIP (선박 정보)
- SHIP_ID (Key) — VARCHAR — Primary key — NOT NULL
- COMPANY_ID (Key2) — VARCHAR — Foreign key → TB_SHIP_COMPANY.COMPANY_ID — NOT NULL
- IMO (Field) — NUMBER
- CLSGN (Field2) — VARCHAR
- SHIP_NM (Field3) — VARCHAR
- SHIP_KND (Field4) — VARCHAR
- AIS_LAT (Field5) — DOUBLE
- AIS_LON (Field6) — DOUBLE
- AIS_COG (Field7) — DOUBLE
- AIS_SOG (Field8) — DOUBLE
- AIS_HDG (Field9) — DOUBLE
- AIS_ROT (Field10) — DOUBLE
- DANGER_FLAG (Field11) — VARCHAR
- AIS_RECPTN_TM (Field12) — TIMESTAMP
TB_SHIP_COMPANY (선사 정보)
- COMPANY_ID (Key) — VARCHAR — Primary key — NOT NULL
- COMPANY_NM (Field) — VARCHAR
- COMPANY_NATION (Field2) — VARCHAR
- COMPANY_BIZ_NO (Field3) — VARCHAR
- COMPANY_PRESIDENT (Field4) — VARCHAR
- COMPANY_ADDR (Field5) — VARCHAR
- COMPANY_TEL (Field6) — VARCHAR
- COMPANY_FAX (Field7) — VARCHAR
- COMPANY_MANAGER (Field8) — VARCHAR
- COMPANY_MANAGER_TEL (Field9) — VARCHAR
- COMPANY_MANAGER_EMAIL (Field10) — VARCHAR
- COMPANY_REG_DATE (Field11) — TIMESTAMP
TB_SYSTEM_LOG (시스템 이력)
- LOG_IDX (Key) — NUMBER — Primary key — NOT NULL
- USID (Key2) — VARCHAR — Foreign key → TB_USER.USID — NOT NULL
- USER_TYPE (Field) — VARCHAR
- LOGIN_ID (Field2) — VARCHAR
- LOGIN_DE (Field3) — TIMESTAMP
- LOG_DESC (Field4) — VARCHAR
TB_TRACK (항적 정보)
- SHIP_ID (Key2) — VARCHAR — Foreign key → TB_SHIP.SHIP_ID — NOT NULL
- COMPANY_ID (Key22) — VARCHAR — Foreign key → TB_SHIP.COMPANY_ID — NOT NULL
- SHIP_RECORD_TIME (Field) — TIMESTAMP
- SHIP_LAT (Field2) — DOUBLE
- SHIP_LON (Field3) — DOUBLE
- SHIP_SOG (Field4) — DOUBLE
- SHIP_COG (Field5) — DOUBLE
- SHIP_HDG (Field6) — DOUBLE
- SHIP_ROT (Field7) — DOUBLE
TB_USER (사용자 정보)
- USID (Key) — VARCHAR — Primary key — NOT NULL
- AUTH_IDX (Key2) — NUMBER — Foreign key → TB_AUTH.AUTH_IDX — NOT NULL
- PASSWORD (Field) — VARCHAR
- USER_NM (Field2) — VARCHAR
- REG_DATE (Field4) — TIMESTAMP
TB_USER_GROUP (사용자 그룹)
- GROUP_ID (Key) — NUMBER — Primary key — NOT NULL
- GROUP_NM (Field) — VARCHAR
- AUTH_IDX (Key2) — NUMBER — Foreign key → TB_AUTH.AUTH_IDX — NOT NULL