ookubo

Tables (12)

Case (case)

  • case_id — Integer — Primary key — NOT NULL
  • (place_id) — Integer — Primary key — NOT NULL
  • createDate (create_date) — Date
  • departurePlace (departure_place) — placeInfo
  • destinationPlace (destination_place) — placeInfo
  • product — product
  • estimatedCarCapacity (estimated_car_capacity) — Integer
  • estimatedCarNum (estimated_car_num) — Integer
  • driver — driver — Foreign key → driver.driver_id — NOT NULL
  • car — car — Foreign key → carInfo.car_id — NOT NULL

carInfo

  • car_id — Primary key — NOT NULL
  • carNo (car_number) — Integer
  • category — Integer
  • capacity — Integer
  • status — Integer
  • prohibitPlace (prohibit_place) — placeInfo
  • numberColor (number_color) — Integer

disposalPlace

  • place_id — Integer — Foreign key → placeInfo.place_id — NOT NULL
  • placeInfo (place_info) — placeInfo
  • availableItems (available_items) — item — Foreign key → item.itemCode — NOT NULL

driver

  • driver_id — Integer — Primary key — NOT NULL
  • name — String — NOT NULL
  • status — Boolean — NOT NULL
  • telNo (tel_no) — String
  • licence — String
  • prohibitPlace (prohibit_place) — placeInfo
  • position — Integer
  • register_date — Date
  • nightWork (night_work) — Boolean

garage

  • place_id — Integer — Foreign key → placeInfo.place_id — NOT NULL
  • placeInfo (place_info) — placeInfo

item (category)

  • itemCode (item_code) — Integer — Primary key — NOT NULL
  • name — VARCHAR

loadingPlace

  • place_id — Integer — Foreign key → placeInfo.place_id — NOT NULL
  • placeInfo (place_info) — placeInfo

ownedCar

  • car_id — Foreign key → carInfo.car_id — NOT NULL
  • carInfo (car_info) — carInfo
  • priorityDriver (priority_driver) — driver
  • (driver_id) — Integer — Foreign key → driver.driver_id — NOT NULL

placeInfo

  • place_id — Integer — Primary key — NOT NULL
  • name — String
  • address — String
  • openTime (open_time) — Date
  • closeTime (close_time) — Date
  • status — Integer
  • telNo (tel_no) — Integer
  • managerName (manager_name) — String
  • comment — String
  • (driver_id) — Integer — Foreign key → driver.driver_id — NOT NULL
  • (case_id) — Integer — Foreign key → Case.case_id — NOT NULL
  • (place_id2) — Integer — Foreign key → Case.place_id — NOT NULL

product

  • itemCode (item_code) — Integer — Foreign key → item.itemCode — NOT NULL
  • categoryType (category_type) — category — disposal/delivery/mixed
  • (case_id) — Integer — Foreign key → Case.case_id — NOT NULL
  • (place_id) — Integer — Foreign key → Case.place_id — NOT NULL

rentedCar

  • car_id — Foreign key → carInfo.car_id — NOT NULL
  • carInfo (car_info) — carInfo
  • companyName (company_name) — string
  • garageInfo (garage_info) — garage

sourcePlace

  • place_id — Integer — Foreign key → placeInfo.place_id — NOT NULL
  • placeInfo (place_info) — placeInfo
  • usageStatus (usage_status) — Integer
  • availableCarCapacity (available_car_capacity) — Integer
  • availableCarHeight (available_car_height) — Integer
  • registeredCarList (registered_cars) — carInfo
  • needEarlyNotification (early_notification) — Boolean
  • (Key) — Foreign key → carInfo.car_id — NOT NULL