mosic

Tables (15)

p_ai_prompt_logs

  • ai_id (Key) — biginit — Primary key — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • ai_model_name — varchar(255) — NOT NULL
  • ai_response — text — NOT NULL
  • ai_uuid — varchar(36) — NOT NULL
  • created_by — varchar(255)
  • deleted_by — varchar(255)
  • updated_by — varchar(255)
  • user_prompt — text — NOT NULL
  • is_deleted — boolean — NOT NULL
  • is_public — boolean — NOT NULL

p_ai_prompt_templates

  • template_id (Key) — bigint — Primary key — NOT NULL
  • is_deleted — boolean — NOT NULL
  • is_public — boolean — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_by — varchar(255)
  • template_uuid — varchar(36) — NOT NULL
  • updated_by — varchar(255)
  • user_prompt — text — NOT NULL

p_companies

  • company_id (Key) — Primary key — NOT NULL
  • company_uuid — varchar(36) — NOT NULL
  • company_name — varchar(100) — NOT NULL
  • company_address — varchar(255) — NOT NULL
  • company_type — varchar(50) — NOT NULL
  • hub_uuid — varchar(36) — NOT NULL
  • is_public — boolean — NOT NULL
  • is_deleted — boolean — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • created_by — varchar(36) — NOT NULL
  • updated_at — timestamp(6)
  • updated_by — varchar(36)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(36)
  • user_id (user_id2) — biginit — Foreign key → p_users.user_id — NOT NULL

p_delivery

  • delivery_id (Key) — bigint — Primary key — NOT NULL
  • delivery_uuid — varchar(36) — NOT NULL
  • departure_hub_id — varchar(255) — NOT NULL
  • order_id — varchar(255) — NOT NULL
  • total_elapsed_time — double — NOT NULL
  • shipping_end_date — timestamp(6)
  • shipping_start_date — timestamp(6)
  • total_distance — bigint — NOT NULL
  • arrival_hub_id — varchar(255) — NOT NULL
  • delivery_state — varchar(255) — NOT NULL
  • REQUESTED::character — varying
  • IN_TRANSIT::character — varying
  • DELIVERED::character — varying
  • CONFIRMED::character — varying)::text))
  • shipping_address — varchar(255)
  • shipping_manger_id — varchar(255)
  • shipping_manger_slack_id — varchar(255)
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • updated_by — varchar(255)
  • updated_at — timestamp(6)
  • deleted_by — varchar(255)
  • deleted_at — timestamp(6)
  • is_delete — boolean — NOT NULL
  • is_public — boolean — NOT NULL

p_delivery_drivers

  • delivery_driver_id (Key) — bigint — Primary key — NOT NULL
  • delivery_driver_uuid — varchar(255) — NOT NULL
  • hub_uuid — varchar(255)
  • slack_email — varchar(100) — NOT NULL
  • type — varchar(7) — NOT NULL
  • COMPANY::character — varying)::text))
  • delivery_order — integer — NOT NULL
  • is_latest — boolean
  • is_public — boolean — NOT NULL
  • is_deleted — boolean — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • created_by — varchar(36) — NOT NULL
  • updated_at — timestamp(6)
  • updated_by — varchar(36)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(36)

p_delivery_route

  • delivery_route_id (Key) — bigint — Primary key — NOT NULL
  • delivery_id (Key2) — bigint — Foreign key → p_delivery.delivery_id — NOT NULL
  • estimated_distance — double
  • real_elapsed_time — numeric(21)
  • estimated_elapsed_time — bigint
  • sequence — bigint — NOT NULL
  • arrival_hub_id — varchar(255) — NOT NULL
  • arrival_hub_name — varchar(255) — NOT NULL
  • departure_hub_id — varchar(255) — NOT NULL
  • departure_hub_name — varchar(255) — NOT NULL
  • hub_delivery_driver — varchar(255)
  • route_state — varchar(255)
  • IN_TRANSIT_TO_HUB::character — varying
  • AT_ARRIVAL_HUB::character — varying
  • OUT_FOR_DELIVERY::character — varying
  • IN_TRANSIT_TO_COMPANY::character — varying
  • DELIVERED::character — varying)::text))

p_hub_transfers

  • hub_transfer_id (Key) — bigint — Primary key — NOT NULL
  • hub_transfer_uuid — varchar(36) — NOT NULL
  • departure_hub_id — bigint — NOT NULL
  • arrival_hub_id — bigint — NOT NULL
  • estimated_time — integer — NOT NULL
  • estimated_distance — double — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • created_by — varchar(36) — NOT NULL
  • updated_at — timestamp(6)
  • updated_by — varchar(36)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(36)
  • is_deleted — boolean — NOT NULL
  • is_public — boolean — NOT NULL

p_hubs

  • hub_id (Key) — bigint — Primary key — NOT NULL
  • hub_uuid — varchar(36) — NOT NULL
  • manager_id — bigint
  • name — varchar(200) — NOT NULL
  • address — varchar(255) — NOT NULL
  • latitude — double — NOT NULL
  • longitude — double — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • created_by — varchar(36) — NOT NULL
  • updated_at — timestamp(6)
  • updated_by — varchar(36)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(36)
  • is_deleted — boolean — NOT NULL
  • is_public — boolean — NOT NULL

p_order_details

  • order_detail_id (Key) — bigint — Primary key — NOT NULL
  • is_delete — boolean — NOT NULL
  • is_public — boolean — NOT NULL
  • created_at — timestamp(6)
  • deleted_at — timestamp(6)
  • quantity — bigint — NOT NULL
  • unit_price — bigint — NOT NULL
  • updated_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_by — varchar(255)
  • order_detail_uuid — varchar(36) — NOT NULL
  • product_id — varchar(255) — NOT NULL
  • product_name — varchar(255) — NOT NULL
  • updated_by — varchar(255)
  • order_id (Key2) — bigint — Foreign key → p_orders.order_id — NOT NULL

p_order_state_history

  • order_state_history_id (Key) — bigint — Primary key — NOT NULL
  • order_id (Key2) — bigint — Foreign key → p_orders.order_id — NOT NULL
  • is_delete — boolean — NOT NULL
  • is_public — boolean — NOT NULL
  • created_at — timestamp(6)
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_by — varchar(255)
  • order_state — varchar(255) — NOT NULL
  • CREATED::character — varying
  • SHIPPED::character — varying
  • DELIVERED::character — varying
  • CONFIRMED::character — varying
  • CANCELLED::character — varying)::text))
  • updated_by — varchar(255)

p_orders

  • order_id (Key) — bigint — Primary key — NOT NULL
  • is_delete — boolean — NOT NULL
  • is_public — boolean — NOT NULL
  • created_at — timestamp(6)
  • deleted_at — timestamp(6)
  • order_date — timestamp(6) — NOT NULL
  • total_amount — bigint — NOT NULL
  • total_quantity — bigint — NOT NULL
  • updated_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_by — varchar(255)
  • order_state — varchar(255) — NOT NULL
  • CREATED::character — varying
  • SHIPPED::character — varying
  • DELIVERED::character — varying
  • CONFIRMED::character — varying
  • CANCELLED::character — varying)::text))
  • order_uuid — varchar(36) — NOT NULL
  • receiver_company_id — varchar(255) — NOT NULL
  • supplier_company_id — varchar(255) — NOT NULL
  • updated_by — varchar(255)

p_products

  • product_id (Key) — bigint — Primary key — NOT NULL
  • is_delete — boolean — NOT NULL
  • is_public — boolean — NOT NULL
  • created_at — timestamp(6)
  • deleted_at — timestamp(6)
  • product_price — bigint — NOT NULL
  • stock_quantity — bigint — NOT NULL
  • updated_at — timestamp(6)
  • version — bigint
  • company_id — varchar(255) — NOT NULL
  • created_by — varchar(255)
  • deleted_by — varchar(255)
  • product_description — varchar(255) — NOT NULL
  • product_hub_id — varchar(255) — NOT NULL
  • product_name — varchar(255) — NOT NULL
  • product_uuid — varchar(36) — NOT NULL
  • updated_by — varchar(255)

p_products_stock_history

  • product_stock_history_id (Key) — bigint — Primary key — NOT NULL
  • is_delete — boolean — NOT NULL
  • is_public — boolean — NOT NULL
  • created_at — timestamp(6)
  • deleted_at — timestamp(6)
  • product_id — bigint
  • quantity — bigint
  • updated_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_by — varchar(255)
  • stock_type — varchar(255)
  • OUTBOUND::character — varying
  • CANCEL::character — varying)::text))
  • updated_by — varchar(255)

p_slack_messages

  • slack_message_id (Key) — bigint — Primary key — NOT NULL
  • is_deleted — boolean — NOT NULL
  • is_public — boolean — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • created_by — varchar(255)
  • deleted_by — varchar(255)
  • receiver_slack_email — varchar(255) — NOT NULL
  • receiver_slack_id — varchar(255) — NOT NULL
  • slack_message_uuid — varchar(36) — NOT NULL
  • text — text — NOT NULL
  • updated_by — varchar(255)

p_users

  • user_id — biginit — Primary key — NOT NULL
  • user_uuid — varchar(36) — NOT NULL
  • username — varchar(100) — NOT NULL
  • password — varchar(100) — NOT NULL
  • role — varchar(50) — NOT NULL
  • slack_email — varchar(100) — NOT NULL
  • is_public — boolean — NOT NULL
  • is_activated — boolean — NOT NULL
  • is_deleted — boolean — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • created_by — varchar(36) — NOT NULL
  • updated_at — timestamp(6)
  • updated_by — varchar(36)
  • deleted_at — timestamp(6)
  • deleted_by — varchar(36)