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