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