asdf
Tables (17)
Car
- car_id — VARCHAR(50)
- car_number — VARCHAR(50)
- category_id — INT
- capacity — INT
- status — SMALLINT
- number_color — SMALLINT
CarCategory
- category_id — INT
- name — VARCHAR(100) — NOT NULL
CarProhibitPlace
- car_id — VARCHAR(50) — Primary key — NOT NULL
- place_id — INT — Primary key — NOT NULL
CaseMaster
- case_id — INT
- create_date — DATE
- departure_place_id — INT
- destination_place_id — INT
- estimated_car_capacity — INT
- estimated_car_num — INT
- driver_id — INT
- car_id — VARCHAR(50)
- status — SMALLINT
Category
- category_id — INT
- name — VARCHAR(100) — NOT NULL
DisposalPlace
- place_id — INT
- available_items — INT
Driver
- driver_id — INT
- name — VARCHAR(200) — NOT NULL
- status — BOOLEAN — NOT NULL
- tel_no — VARCHAR(50)
- licence_no — VARCHAR(100)
- position — VARCHAR(50)
- register_date — DATE
- night_work — BOOLEAN
DriverProhibitPlace
- driver_id — INT — Primary key — NOT NULL
- place_id — INT — Primary key — NOT NULL
Garage
- garage_id — INT
- place_id — INT — NOT NULL
- name — VARCHAR(200)
OwnedCar
- car_id — VARCHAR(50)
- priority_driver_id — INT
- driver_id — INT
Place
- place_id — INT
- name — VARCHAR(255) — NOT NULL
- address — VARCHAR(500)
- tel_no — VARCHAR(50)
- manager_name — VARCHAR(100)
- comment — TEXT — EX
- open_time — TIME
- close_time — TIME
- status — SMALLINT
PlaceCategory
- place_id — INT — Primary key — NOT NULL
- place_type_id — INT — Primary key — NOT NULL
PlaceType
- place_type_id — INT
- name — VARCHAR(100) — NOT NULL
Product
- product_id — INT
- item_code — INT — NOT NULL
- category_id — INT
- case_id — INT
- place_id — INT
RentedCar
- car_id — VARCHAR(50)
- company_name — VARCHAR(200)
- garage_id — INT
SourcePlace
- place_id — INT
- usage_status — SMALLINT
- available_car_capacity — INT
- available_car_height — INT
- early_notification — BOOLEAN