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