88
Tables (15)
add_ons
- id — integer — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- sub_title — varchar(100) — NOT NULL
- base_monthly_rate — integer — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
chat_messages
- id — bigint — Primary key — NOT NULL
- chat_id — uuid — Foreign key → chats.id — NOT NULL
- sender_type — varchar(10) — NOT NULL
- content — text — NOT NULL
- created_at — timestamptz — NOT NULL
chat_summary
- id — integer — Primary key — NOT NULL
- chat_id — uuid — Foreign key → chats.id — NOT NULL
- summary — text — NOT NULL
- last_message_id — bigint — Foreign key → chat_messages.id
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
chats
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- keywords — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
membership_brands
- id — varchar(50) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- category — varchar(50) — NOT NULL
- discount_rules — jsonb — NOT NULL
- icon — varchar(50) — NOT NULL
- created_at — timestamptz — NOT NULL
missions
- id — integer — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- title — varchar(100) — NOT NULL
- description — varchar(255)
- reward_point — integer — NOT NULL
- period — varchar(20) — NOT NULL
- created_at — timestamptz — NOT NULL
plans
- id — integer — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- description — varchar(100) — NOT NULL
- monthly_fee — integer — NOT NULL
- data_allowance — varchar(100) — NOT NULL
- voice_sms — varchar(100) — NOT NULL
- benefits — jsonb
- created_at — timestamptz — NOT NULL
point_history
- id — bigint — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- amount — integer — NOT NULL
- type — varchar(20) — NOT NULL
- reason — varchar(100) — NOT NULL
- balance_after — integer — NOT NULL
- created_at — timestamptz — NOT NULL
subscriptions
- id — integer — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- base_monthly_fee — integer — NOT NULL
- discount — integer — NOT NULL
- highlight — varchar(100)
- description — varchar(255)
- created_at — timestamptz — NOT NULL
user_add_ons
- id — integer — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- add_on_id — integer — Foreign key → add_ons.id — NOT NULL
- status — varchar(20) — NOT NULL
- started_at — date — NOT NULL
- ended_at — date
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
user_event_logs
- id — bigint — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- event_type — varchar(50) — NOT NULL
- event_details — jsonb
- created_at — timestamptz — NOT NULL
user_missions
- id — integer — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- mission_id — integer — Foreign key → missions.id — NOT NULL
- completed_date — date — NOT NULL
- created_at — timestamptz — NOT NULL
user_monthly_usage
- id — integer — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- billing_month — varchar(7) — NOT NULL
- data_used_mb — integer — NOT NULL
- created_at — timestamptz — NOT NULL
user_subscriptions
- id — integer — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- subscription_id — integer — Foreign key → subscriptions.id — NOT NULL
- next_billing_date — date — NOT NULL
- status — varchar(20) — NOT NULL
- created_at — timestamptz — NOT NULL
users
- id — uuid — Primary key — NOT NULL
- name — varchar(50)
- contact — varchar(20)
- current_plan_id — integer — Foreign key → plans.id
- birth — date
- gender — varchar(10)
- remaining_data — integer — NOT NULL
- data_limit — integer
- point — integer — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL