ㅅㄷㄴㅅ
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