---
source: tests/integration/snapshot.rs
expression: symbols
---
- symbol: pgscip . . . public/active_orders().
  display_name: active_orders
  kind: Function
  enclosing_symbol: ""
  doc: "FUNCTION public.active_orders(p_user_id uuid, p_status public.order_status) RETURNS orders"
  relationships:
    - "pgscip . . . public/order_status#"
- symbol: "pgscip . . . public/address#"
  display_name: address
  kind: Struct
  enclosing_symbol: ""
  doc: TYPE public.address AS COMPOSITE
  relationships: []
- symbol: "pgscip . . . public/address#city."
  display_name: city
  kind: Field
  enclosing_symbol: "pgscip . . . public/address#"
  doc: text
  relationships: []
- symbol: "pgscip . . . public/address#street."
  display_name: street
  kind: Field
  enclosing_symbol: "pgscip . . . public/address#"
  doc: text
  relationships: []
- symbol: "pgscip . . . public/address#zip."
  display_name: zip
  kind: Field
  enclosing_symbol: "pgscip . . . public/address#"
  doc: text
  relationships: []
- symbol: pgscip . . . public/idx_orders_pending.
  display_name: idx_orders_pending
  kind: Property
  enclosing_symbol: ""
  doc: INDEX idx_orders_pending ON public.orders
  relationships:
    - pgscip . . . public/orders.
- symbol: pgscip . . . public/idx_orders_user_id.
  display_name: idx_orders_user_id
  kind: Property
  enclosing_symbol: ""
  doc: INDEX idx_orders_user_id ON public.orders
  relationships:
    - pgscip . . . public/orders.
- symbol: pgscip . . . public/idx_orders_user_status.
  display_name: idx_orders_user_status
  kind: Property
  enclosing_symbol: ""
  doc: INDEX idx_orders_user_status ON public.orders
  relationships:
    - pgscip . . . public/orders.
- symbol: pgscip . . . public/idx_products_search.
  display_name: idx_products_search
  kind: Property
  enclosing_symbol: ""
  doc: INDEX idx_products_search ON public.products
  relationships:
    - pgscip . . . public/products.
- symbol: pgscip . . . public/idx_users_email.
  display_name: idx_users_email
  kind: Property
  enclosing_symbol: ""
  doc: INDEX idx_users_email ON public.users
  relationships:
    - pgscip . . . public/users.
- symbol: pgscip . . . public/idx_users_email_lower.
  display_name: idx_users_email_lower
  kind: Property
  enclosing_symbol: ""
  doc: INDEX idx_users_email_lower ON public.users
  relationships:
    - pgscip . . . public/users.
- symbol: "pgscip . . . public/item_condition#"
  display_name: item_condition
  kind: Enum
  enclosing_symbol: ""
  doc: TYPE public.item_condition AS ENUM
  relationships: []
- symbol: "pgscip . . . public/order_items#id."
  display_name: id
  kind: Field
  enclosing_symbol: pgscip . . . public/order_items.
  doc: int8 NOT NULL
  relationships: []
- symbol: "pgscip . . . public/order_items#order_id."
  display_name: order_id
  kind: Field
  enclosing_symbol: pgscip . . . public/order_items.
  doc: int8 NOT NULL
  relationships:
    - "pgscip . . . public/orders#id."
- symbol: "pgscip . . . public/order_items#product_id."
  display_name: product_id
  kind: Field
  enclosing_symbol: pgscip . . . public/order_items.
  doc: int8 NOT NULL
  relationships:
    - "pgscip . . . public/products#id."
- symbol: "pgscip . . . public/order_items#quantity."
  display_name: quantity
  kind: Field
  enclosing_symbol: pgscip . . . public/order_items.
  doc: int4 NOT NULL
  relationships: []
- symbol: pgscip . . . public/order_items.
  display_name: order_items
  kind: Struct
  enclosing_symbol: ""
  doc: TABLE public.order_items
  relationships: []
- symbol: "pgscip . . . public/order_status#"
  display_name: order_status
  kind: Enum
  enclosing_symbol: ""
  doc: TYPE public.order_status AS ENUM
  relationships: []
- symbol: pgscip . . . public/order_summary.
  display_name: order_summary
  kind: Class
  enclosing_symbol: ""
  doc: VIEW public.order_summary
  relationships:
    - pgscip . . . public/orders.
    - pgscip . . . public/users.
- symbol: "pgscip . . . public/orders#created_at."
  display_name: created_at
  kind: Field
  enclosing_symbol: pgscip . . . public/orders.
  doc: timestamptz NOT NULL
  relationships: []
- symbol: "pgscip . . . public/orders#id."
  display_name: id
  kind: Field
  enclosing_symbol: pgscip . . . public/orders.
  doc: int8 NOT NULL
  relationships: []
- symbol: "pgscip . . . public/orders#status."
  display_name: status
  kind: Field
  enclosing_symbol: pgscip . . . public/orders.
  doc: public.order_status NOT NULL
  relationships:
    - "pgscip . . . public/order_status#"
- symbol: "pgscip . . . public/orders#total."
  display_name: total
  kind: Field
  enclosing_symbol: pgscip . . . public/orders.
  doc: numeric NOT NULL
  relationships: []
- symbol: "pgscip . . . public/orders#user_id."
  display_name: user_id
  kind: Field
  enclosing_symbol: pgscip . . . public/orders.
  doc: uuid NOT NULL
  relationships:
    - "pgscip . . . public/users#id."
- symbol: pgscip . . . public/orders.
  display_name: orders
  kind: Struct
  enclosing_symbol: ""
  doc: TABLE public.orders
  relationships: []
- symbol: pgscip . . . public/orders_isolation.
  display_name: orders_isolation
  kind: Attribute
  enclosing_symbol: ""
  doc: POLICY orders_isolation ON public.orders
  relationships:
    - pgscip . . . public/orders.
- symbol: pgscip . . . public/orders_updated_at.
  display_name: orders_updated_at
  kind: Event
  enclosing_symbol: ""
  doc: TRIGGER orders_updated_at ON public.orders
  relationships:
    - pgscip . . . public/orders.
    - pgscip . . . public/set_updated_at().
- symbol: "pgscip . . . public/products#condition."
  display_name: condition
  kind: Field
  enclosing_symbol: pgscip . . . public/products.
  doc: public.item_condition NOT NULL
  relationships:
    - "pgscip . . . public/item_condition#"
- symbol: "pgscip . . . public/products#id."
  display_name: id
  kind: Field
  enclosing_symbol: pgscip . . . public/products.
  doc: int8 NOT NULL
  relationships: []
- symbol: "pgscip . . . public/products#name."
  display_name: name
  kind: Field
  enclosing_symbol: pgscip . . . public/products.
  doc: text NOT NULL
  relationships: []
- symbol: "pgscip . . . public/products#search_vec."
  display_name: search_vec
  kind: Field
  enclosing_symbol: pgscip . . . public/products.
  doc: tsvector
  relationships: []
- symbol: pgscip . . . public/products.
  display_name: products
  kind: Struct
  enclosing_symbol: ""
  doc: TABLE public.products
  relationships: []
- symbol: pgscip . . . public/set_updated_at().
  display_name: set_updated_at
  kind: Function
  enclosing_symbol: ""
  doc: FUNCTION public.set_updated_at()
  relationships: []
- symbol: "pgscip . . . public/users#created_at."
  display_name: created_at
  kind: Field
  enclosing_symbol: pgscip . . . public/users.
  doc: timestamptz NOT NULL
  relationships: []
- symbol: "pgscip . . . public/users#deleted_at."
  display_name: deleted_at
  kind: Field
  enclosing_symbol: pgscip . . . public/users.
  doc: timestamptz
  relationships: []
- symbol: "pgscip . . . public/users#email."
  display_name: email
  kind: Field
  enclosing_symbol: pgscip . . . public/users.
  doc: text NOT NULL — unique login email
  relationships: []
- symbol: "pgscip . . . public/users#id."
  display_name: id
  kind: Field
  enclosing_symbol: pgscip . . . public/users.
  doc: uuid NOT NULL
  relationships: []
- symbol: pgscip . . . public/users.
  display_name: users
  kind: Struct
  enclosing_symbol: ""
  doc: TABLE public.users
  relationships: []
