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