RE: port
Tables (16)
account
- id — bigserial — Primary key — NOT NULL
- email — varchar — NOT NULL
- password — varchar — NOT NULL
- address — varchar
- firtst_name — varchar — NOT NULL
- last_name — varchar — NOT NULL
- birth — timestamp
- phone_number — varchar
- picture_id — int8
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
company_schedule
- id — int8 — Primary key — NOT NULL
- event_date — date — NOT NULL
- event_title — varchar(255) — NOT NULL
- event_description — text
- created_by — varchar(100) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
group
- id — bigserial — Primary key — NOT NULL
- name — varchar
- cargo_owner — varchar
- unloading_contractor_name — varchar
- manager_id — int8
- loading_location — varchar
- unloading_location — varchar
- item — varchar
- shift_type — bpchar(1)
- work_type — bpchar(1)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
group_search_tag
- id — bigserial — Primary key — NOT NULL
- group_id — int8
- tag_name — varchar
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
group_vehicle
- id — bigserial — Primary key — NOT NULL
- group_id — int8
- vehicle_info_id — int8
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
operation_picture
- id — bigserial — Primary key — NOT NULL
- file_name — varchar
- file_size — int8
- original_name — varchar
- url — varchar
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
profile
- id — bigserial — Primary key — NOT NULL
- firtst_name — varchar — NOT NULL
- last_name — varchar — NOT NULL
- birth — timestamp
- phone_number — varchar — NOT NULL
- company — varchar
- profile_type — varchar — NOT NULL
- profile_picture_id — int8
profile_business_partner
- id — bigserial — Primary key — NOT NULL
- position — varchar
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- profile_id — int8 — NOT NULL
profile_driver
- id — bigserial — Primary key — NOT NULL
- night_shift — bool — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- profile_id — int8 — NOT NULL
- vehicle_info_id — int8
profile_picture
- id — int8 — Primary key — NOT NULL
- file_name — varchar
- file_size — int8
- original_name — varchar
- url — varchar
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
vehicle_info
- id — int8 — Primary key — NOT NULL
- vihicle_number — varchar
- vehicle_type — varchar
- vehicle_owner_name — varchar
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
vehicle_movement_log
- id — bigserial — Primary key — NOT NULL
- load_time — timestamp
- unload_time — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- vehicle_rotation_id — int8
work_dispatch_issue
- id — bigserial — Primary key — NOT NULL
- vehicle_info_id — int8
- issue_description — varchar
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
work_dispatch_vehicle_rotation
- id — int8 — Primary key — NOT NULL
- work_load — int4 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- operation_picture_id — int8
- round_number — int2
- dispatch_vehicle_id — int8
work_dispatch_vihicle
- id — int8 — Primary key — NOT NULL
- work_log_id — int8
- total_work_load — int4
- total_rotation — int2
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- vehicle_info_id — int8
- vehicle_status — bpchar(1)
work_log
- id — bigserial — Primary key — NOT NULL
- cargo_owner — varchar — NOT NULL
- item_name — varchar
- total_rotations — int2 — NOT NULL
- total_vehicle — int2 — NOT NULL
- total_work_load — int4
- departure_location — varchar
- arrival_location — varchar
- status — bpchar(1)
- work_date — timestamp
- work_shift — bpchar(1)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL