Travelog
Tables (12)
EXPENSE
- USER_ID_NO — BIGINT — Foreign key → TRAVELOG_TABLE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → TRAVELOG_TABLE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- DATE — VARCHAR(6)
- CATEGORY — VARCHAR(8)
- DESCRIPTION — VARCHAR(50)
- BUDGET — INT(100)
- ACTUAL — INT(100)
- CASH_CARD
- NOTES — VARCHAR(30)
RESERVATION_ACCOMODATION
- USER_ID_NO — BIGINT — Foreign key → TRAVELOG_TABLE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → TRAVELOG_TABLE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- CHECK_IN — VARCHAR(4)
- CHECK_OUT — VARCHAR(4)
- PHONE — INT(11)
- DATE — VARCHAR(12)
- ADDRESS — VARCHAR(255)
RESERVATION_DEPARTURE
- USER_ID_NO — BIGINT — Foreign key → TRAVELOG_TABLE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → TRAVELOG_TABLE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- DEPARTURE_DATE — VARCHAR(6)
- DEPARTURE_FROM — VARCHAR(3)
- DEPARTURE_DESTINATION — VARCHAR(3)
- DEPARTURE_TERMINAL — VARCHAR(2)
- DEPARTURE_GATE — INT(3)
- DEPARTURE_DEPARTURE_TIME — VARCHAR(4)
- DEPARTURE_ARRIVAL_TIME — VARCHAR(4)
- DEPARTURE_FLIGHT_NUMBER — VARCHAR(7)
- DEPARTURE_NOTES — VARCHAR(30)
RESERVATION_ETC
- USER_ID_NO — BIGINT — Foreign key → TRAVELOG_TABLE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → TRAVELOG_TABLE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- DATE — VARCHAR(6)
- CATEGORY — VARCHAR(6)
- DESCRIPTION — VARCHAR(50)
- NOTES — VARCHAR(10)
RESERVATION_RETURN
- USER_ID_NO — BIGINT — Foreign key → TRAVELOG_TABLE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → TRAVELOG_TABLE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- RETURN_DATE — VARCHAR(6)
- RETURN_FROM — VARCHAR(3)
- RETURN_DESTINATION — VARCHAR(3)
- RETURN_TERMINAL — VARCHAR(2)
- RETURN_GATE — INT(3)
- RETURN_DEPARTURE_TIME — VARCHAR(4)
- RETURN_ARRIVAL_TIME — VARCHAR(4)
- RETURN_FLIGHT_NUMBER — VARCHAR(7)
- RETURN_NOTES — VARCHAR(30)
SCHEDULE
- SCHEDULE_DATE — VARCHAR(12) — Primary key — NOT NULL
- USER_ID_NO — BIGINT — Foreign key → TRAVELOG_TABLE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → TRAVELOG_TABLE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
SCHEDULE_NOTES
- SCHEDULE_DATE — VARCHAR(12) — Foreign key → SCHEDULE.SCHEDULE_DATE — NOT NULL
- USER_ID_NO — BIGINT — Foreign key → SCHEDULE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → SCHEDULE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- NOTES — VARCHAR(255)
SCHEDULE_TIME_LINE
- SCHEDULE_DATE — VARCHAR(12) — Foreign key → SCHEDULE.SCHEDULE_DATE — NOT NULL
- USER_ID_NO — BIGINT — Foreign key → SCHEDULE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → SCHEDULE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- TIME — VARCHAR(4)
- PLAN — VARCHAR(50)
- NOTES — VARCHAR(10)
TRAVELOG_DATA
- USER_ID_NO — BIGINT — Foreign key → TRAVELOG_TABLE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → TRAVELOG_TABLE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- COUNTRY — VARCHAR(20)
- CITY — VARCHAR(20)
- START_DATE — VARCHAR(6)
- END_DATE — VARCHAR(6)
- ADULTS — INT(3)
- CHILDREN — INT(3)
- PETS — INT(3)
- NIGHTS — INT(3)
TRAVELOG_LIST
- USER_ID_NO — BIGINT — Foreign key → TRAVELOG_TABLE.USER_ID_NO — NOT NULL
- TRABLE_NO — BIGINT — Foreign key → TRAVELOG_TABLE.TRABLE_NO — NOT NULL — AUTO_INCRIMENT
- CLOTHING — VARCHAR(20)
- HAND_LUGGAGE — VARCHAR(20)
- TOILETRIES — VARCHAR(20)
- TECHNOLOGY — VARCHAR(20)
- THINGS_TO_CHECK — VARCHAR(40)
TRAVELOG_TABLE
- TRABLE_NO — BIGINT — Primary key — NOT NULL — AUTO_INCRIMENT
- USER_ID_NO — BIGINT — Foreign key → USER.USER_ID_NO — NOT NULL
- TRABLE_COUNTRY — VARCHAR(20)
- TRABLE_CITY — VARCHAR(20)
- TRABLE_DATE — VARCHAR(12) — NOT NULL
USER
- USER_ID_NO — BIGINT — Primary key — NOT NULL
- USER_EMAIL — VARCHAR(20) — NOT NULL
- USER_PW — VARCHAR(12) — NOT NULL
- USER_NAME — VARCHAR(25) — NOT NULL