4e:um kdh

Tables (13)

applied_discounts

  • applied_id — BIGSERIAL — Primary key
  • sub_id — UUID — NOT NULL
  • discount_id — BIGINT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • is_active — BOOLEAN

discounts

  • discount_id — BIGSERIAL — Primary key
  • name — VARCHAR(100) — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • rules — JSONB — NOT NULL
  • valid_from — DATE — NOT NULL
  • valid_to — DATE

group_members

  • group_id — UUID — Primary key — NOT NULL
  • user_id — UUID — Primary key — NOT NULL
  • user_id (user_id2) — UUID — Foreign key → users.user_id
  • group_id (group_id2) — UUID — Foreign key → groups.group_id
  • role — VARCHAR(20)
  • joined_at — TIMESTAMP

groups

  • group_id — UUID — Primary key
  • user_id — UUID — Foreign key → users.user_id
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • owner_id — UUID — NOT NULL
  • created_at — TIMESTAMP

invoice_items

  • item_id — BIGSERIAL — Primary key
  • invoice_id — UUID — NOT NULL
  • billing_ym — VARCHAR(6) — NOT NULL
  • description — VARCHAR(255)
  • type — VARCHAR(20)
  • amount — DECIMAL(15, 2) — NOT NULL

invoices

  • invoice_id — UUID — Primary key
  • user_id — UUID — NOT NULL
  • billing_ym — VARCHAR(6) — NOT NULL
  • total_amount — DECIMAL(15, 2) — NOT NULL
  • discount_amt — DECIMAL(15, 2)
  • status — VARCHAR(20)
  • due_date — DATE
  • created_at — TIMESTAMP

noti_history

  • history_id — BIGSERIAL — Primary key
  • user_id — UUID — NOT NULL
  • tmpl_id — BIGINT — NOT NULL
  • sent_at — TIMESTAMP
  • dest_info — VARCHAR(255)
  • content — TEXT
  • status — VARCHAR(20)

plans

  • plan_id — BIGSERIAL — Primary key
  • product_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — DECIMAL(15, 2) — NOT NULL
  • billing_cycle — VARCHAR(20) — NOT NULL

products

  • product_id — BIGSERIAL — Primary key
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN

subscriptions

  • sub_id — UUID — Primary key
  • user_id — UUID — NOT NULL
  • group_id — UUID
  • plan_id — BIGINT — NOT NULL
  • status — VARCHAR(20)
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP

templates

  • tmpl_id — BIGSERIAL — Primary key
  • name — VARCHAR(100) — NOT NULL
  • channel — VARCHAR(10) — NOT NULL
  • subject — VARCHAR(200)
  • body — TEXT — NOT NULL
  • variables — JSONB
  • status — VARCHAR(20)
  • version — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

usage_daily

  • usage_id — BIGSERIAL — Primary key
  • sub_id — UUID — NOT NULL
  • usage_date — DATE — NOT NULL
  • amount — BIGINT
  • unit — VARCHAR(10)

users

  • user_id — UUID — Primary key
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP