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