ㅅㄷㄴㅅ

Tables (6)

AIRLINE

  • AIRLINE_ID — NUMBER — Primary key — NOT NULL
  • AIRLINE_NAME — VARCHAR2

COUNTRY

  • COUNTRY_ID — NUMBER — Primary key — NOT NULL
  • AIRPORT_CODE — VARCHAR2
  • AIRPORT_ENG_NAME — VARCHAR2
  • AIRPORT_NAME — VARCHAR2
  • CITY_CODE — VARCHAR2
  • CITY_ENG_NAME — VARCHAR2
  • COUNTRY_ENG_NAME — VARCHAR2
  • COUNTRY_NAME — VARCHAR2

FLIGHT

  • FLIGHT_NO — VARCHAR2 — Primary key — NOT NULL
  • FLIGHT_DATE — TIMESTAMP
  • AIRLINE_ID — NUMBER — Foreign key → AIRLINE.AIRLINE_ID

MAWB

  • MAWB_NO — VARCHAR2 — Primary key — NOT NULL
  • DEST — VARCHAR2 — NOT NULL
  • MAWB_CRTDTTM — TIMESTAMP
  • ORG — VARCHAR2 — NOT NULL
  • FLIGHT_NO — VARCHAR2 — Foreign key → FLIGHT.FLIGHT_NO
  • USER_ID — VARCHAR2 — Foreign key → USERS.USER_ID

USERS

  • USER_ID — VARCHAR2 — Primary key — NOT NULL
  • COMPANY_DPRTM — VARCHAR2 — NOT NULL
  • COMPANY_NAME — VARCHAR2 — NOT NULL
  • CONPANY_PHNN — VARCHAR2 — NOT NULL
  • USER_CRT_DT_DM — TIMESTAMP — NOT NULL
  • USER_EMAIL — VARCHAR2 — NOT NULL
  • USER_MDF_DT_DM — TIMESTAMP — NOT NULL
  • USER_NAME — VARCHAR2 — NOT NULL
  • USER_PHNN — VARCHAR2 — NOT NULL
  • USER_PW — VARCHAR2 — NOT NULL

VOLUME

  • VOLUME_ID — VARCHAR2 — Primary key — NOT NULL
  • CCTV1IMG_PATH — VARCHAR2
  • CCTV2IMG_PATH — VARCHAR2
  • IMG_PATH_3D — VARCHAR2
  • VOLUME_CRTDTDM — TIMESTAMP
  • VOLUME_HEIGHT — FLOAT
  • VOLUME_LENGTH — FLOAT
  • VOLUME_MDFDTTM — TIMESTAMP
  • VOLUME_WEIGHT — FLOAT
  • VOLUME_WIDTH — FLOAT
  • MAWB_NO — VARCHAR2 — Foreign key → MAWB.MAWB_NO