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