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