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)