popcorn

Tables (12)

p_checkins

  • checkin_id — UUID
  • order_id — UUID — NOT NULL
  • order_qr_code_id — UUID — NOT NULL
  • created_at — timestamp — NOT NULL
  • created_by — BIGINT

p_customer_addresses

  • addr_id — UUID
  • user_id — BIGINT — NOT NULL
  • addr_name — varchar(50) — NOT NULL
  • address1 — varchar(255) — NOT NULL
  • address2 — varchar(255)
  • postal_code — varchar(10)
  • is_default — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_goods_variants

  • goods_id — UUID
  • popup_id — UUID — NOT NULL
  • stock_unit — varchar(64)
  • goods_name — varchar(100) — NOT NULL
  • goods_price — int — NOT NULL
  • stock — int — NOT NULL
  • is_active — boolean
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_order_goods

  • order_goods_id — UUID
  • order_id — UUID — NOT NULL
  • schedule_id — UUID
  • goods_variant_id — UUID
  • qty — int — NOT NULL
  • unit_price — int — NOT NULL
  • price — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_order_qr_codes

  • qr_id — UUID
  • order_id — UUID — NOT NULL
  • qr_code — varchar(255) — NOT NULL
  • expires_at — timestamp
  • created_at — timestamp — NOT NULL
  • created_by — BIGINT

p_order_status_histories

  • order_status_id — UUID
  • order_id — UUID — NOT NULL
  • from_status — order_status
  • to_status — order_status — NOT NULL
  • reason — varchar(255)
  • changed_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_orders

  • order_id — UUID
  • order_no — varchar(32)
  • user_id — BIGINT — NOT NULL
  • store_id — UUID — NOT NULL
  • status — order_status — NOT NULL
  • cancelable_until — timestamp
  • total_price — int — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_payments

  • payment_id — UUID
  • order_id — UUID — NOT NULL
  • method — payment_method — NOT NULL
  • status — payment_status — NOT NULL
  • amount — int — NOT NULL
  • raw_payload — text
  • approved_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_popup_schedules

  • schedule_id — UUID
  • popup_id — UUID — NOT NULL
  • start_at — timestamp — NOT NULL
  • end_at — timestamp — NOT NULL
  • price — int — NOT NULL
  • capacity — int — NOT NULL
  • remaining_capacity — int — NOT NULL
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_popups

  • popup_id — UUID
  • store_id — UUID — NOT NULL
  • title — varchar(200) — NOT NULL
  • description — text
  • category — popup_category — NOT NULL
  • status — popup_status — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_stores

  • store_id — UUID
  • user_id — BIGINT — NOT NULL
  • store_name — varchar(100) — NOT NULL
  • status — store_status — NOT NULL
  • reason — varchar(500)
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT

p_users

  • user_id — BIGSERIAL
  • password — varchar(255) — NOT NULL
  • name — varchar(100) — NOT NULL
  • phone — varchar(11)
  • email — varchar(255) — NOT NULL
  • role — user_role — NOT NULL
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — BIGINT
  • updated_by — BIGINT
  • deleted_by — BIGINT