test
Tables (14)
tbl_notice
- idx — int(11) — Primary key — NOT NULL
- user_idx — int(11)
- agency_idx — int(11) — NOT NULL
- title — varchar(255) — NOT NULL
- contents — text — NOT NULL
- inc_file — varchar(255)
- inc_file_name — varchar(255)
- reg_date — datetime — NOT NULL
tbl_outsourcing
- idx — int(11) — Primary key — NOT NULL
- outsourcing_name — varchar(255) — NOT NULL
- outsourcing_type — char(1) — NOT NULL
- outsourcing_address — varchar(255)
- outsourcing_tel — varchar(20) — NOT NULL
- outsourcing_pic — varchar(50) — NOT NULL
- contract_date — char(10)
- reg_date — datetime — NOT NULL
tbl_outsourcing_transaction
- idx — int(11) — Primary key — NOT NULL
- transaction_type — char(2) — NOT NULL
- agency_idx — int(11) — NOT NULL
- outsourcing_idx — int(11) — NOT NULL
- drone_idx — int(11)
- repair_idx — int(11)
- part_inventory_idx — int(11)
- contents — text — NOT NULL
- reg_date — datetime — NOT NULL
tbl_part_inventory
- idx — int(11) — Primary key — NOT NULL
- part_idx — int(11) — NOT NULL
- outsourcing_idx — int(11)
- agency_idx — int(11)
- repair_idx — int(11)
- part_price — int(11)
- part_amount — int(11)
- purchase_date — date
- contents — text
- in_amount — int(11)
- out_amount — int(11)
- total_amount — int(11)
- reg_date — datetime — NOT NULL
tbl_role
- idx — int(11) — Primary key — NOT NULL
- role_name — varchar(255) — NOT NULL
- role_code — char(3) — NOT NULL
- menu_idx — int(11) — NOT NULL
- reg_date — datetime — NOT NULL
tbl_role_menu
- idx — int(11) — Primary key — NOT NULL
- menu_name — varchar(255) — NOT NULL
- menu_code — char(1) — NOT NULL
- reg_date — datetime — NOT NULL
tbl_schedule
- idx — int(11) — Primary key — NOT NULL
- agency_idx — int(11) — NOT NULL
- area_name — varchar(100) — NOT NULL
- area_address — varchar(255) — NOT NULL
- area_location_x — varchar(20) — NOT NULL
- area_location_y — varchar(20) — NOT NULL
- start_location_x — varchar(20) — NOT NULL
- start_location_y — varchar(20) — NOT NULL
- layover_location_x — varchar(20) — NOT NULL
- layover_location_y — varchar(20) — NOT NULL
- shoot_location_x — varchar(20) — NOT NULL
- shoot_location_y — varchar(20) — NOT NULL
- return_location_x — varchar(20) — NOT NULL
- return_location_y — varchar(20) — NOT NULL
- flight_type — char(1) — NOT NULL
- intersection_type — varchar(2) — NOT NULL
- reg_date — datetime — NOT NULL
tbl_schedule_backup
- idx — int(11) — Primary key — NOT NULL
- idx_original — int(11) — NOT NULL
- agency_idx — int(11) — NOT NULL
- area_name — varchar(100) — NOT NULL
- area_address — varchar(255) — NOT NULL
- area_location_x — varchar(20) — NOT NULL
- area_location_y — varchar(20) — NOT NULL
- start_location_x — varchar(20) — NOT NULL
- start_location_y — varchar(20) — NOT NULL
- layover_location_x — varchar(20) — NOT NULL
- layover_location_y — varchar(20) — NOT NULL
- shoot_location_x — varchar(20) — NOT NULL
- shoot_location_y — varchar(20) — NOT NULL
- return_location_x — varchar(20) — NOT NULL
- return_location_y — varchar(20) — NOT NULL
- flight_type — char(1) — NOT NULL
- intersection_type — varchar(2) — NOT NULL
- reg_date — datetime — NOT NULL
- reg_date_original — datetime — NOT NULL
tbl_schedule_intersection
- idx — int(11) — Primary key — NOT NULL
- schedule_idx — int(11) — NOT NULL
- direction — varchar(10) — NOT NULL
- in_lane — varchar(20)
- out_lane — varchar(20)
- crosswalk — varchar(20) — NOT NULL
- stopline — varchar(20) — NOT NULL
- location — int(11) — NOT NULL
- reg_date — datetime — NOT NULL
- mid — tinyint(4) — NOT NULL
tbl_schedule_intersection_backup
- idx — int(11) — Primary key — NOT NULL
- idx_original — int(11) — NOT NULL
- schedule_idx — int(11) — NOT NULL
- direction — varchar(10) — NOT NULL
- in_lane — varchar(20)
- out_lane — varchar(20)
- crosswalk — varchar(20) — NOT NULL
- stopline — varchar(20) — NOT NULL
- location — int(11) — NOT NULL
- reg_date — datetime — NOT NULL
- reg_date_original — datetime — NOT NULL
- mid — tinyint(4) — NOT NULL
tbl_sg_car_trajectories
- idx — int(11) — Primary key — NOT NULL
- CID — varchar(50) — NOT NULL
- Type — varchar(20) — NOT NULL
- first_frame — int(11) — NOT NULL
- last_frame — int(11) — NOT NULL
- traveltime — decimal(10,5) — NOT NULL
- velocity — decimal(10,5) — NOT NULL
- distance — decimal(10,5) — NOT NULL
- Direction — varchar(20) — NOT NULL
- Stage — text — NOT NULL
- image_id — varchar(255) — NOT NULL
- reg_date — datetime — NOT NULL
tbl_sg_car_trajectories2
- idx — int(11) — Primary key — NOT NULL
- CID — varchar(50) — NOT NULL
- Type — varchar(20) — NOT NULL
- first_frame — int(11) — NOT NULL
- last_frame — int(11) — NOT NULL
- traveltime — decimal(10,5) — NOT NULL
- velocity — decimal(10,5) — NOT NULL
- distance — decimal(10,5) — NOT NULL
- Direction — varchar(20) — NOT NULL
- Direction2 — varchar(20)
- Stage — text — NOT NULL
- image_id — varchar(255) — NOT NULL
- reg_date — datetime — NOT NULL
tbl_sg_density
- idx — int(11) — Primary key — NOT NULL
- Direction — varchar(10) — NOT NULL
- height — decimal(10,5) — NOT NULL
- Total — int(11) — NOT NULL
- Car — int(11) — NOT NULL
- Bus — int(11) — NOT NULL
- Truck — int(11) — NOT NULL
- Bike — int(11) — NOT NULL
- Others — int(11) — NOT NULL
- Observation_Time — int(11) — NOT NULL
- image_id — varchar(255) — NOT NULL
- reg_date — datetime — NOT NULL
tbl_sg_density2
- idx — int(11) — Primary key — NOT NULL
- Direction — varchar(10) — NOT NULL
- height — decimal(10,5) — NOT NULL
- Total — int(11) — NOT NULL
- Car — int(11) — NOT NULL
- Bus — int(11) — NOT NULL
- Truck — int(11) — NOT NULL
- Bike — int(11) — NOT NULL
- Others — int(11) — NOT NULL
- Observation_Time — int(11) — NOT NULL
- image_id — varchar(255) — NOT NULL
- reg_date — datetime — NOT NULL