sb
Tables (6)
Clients (Untitled)
- tenant_id (Key) — serial — Primary key — NOT NULL
- tenant_name (클라이언트 명) — varchar(255)
- is_subscribing (현재 구독중인지) — boolean
- Field
pay_histories (Untitled2)
- ps_id (Key) — serial — Primary key — NOT NULL
- tenant_id (Key2) — serial — Foreign key → Clients.tenant_id — NOT NULL
- pay_date (Field) — timestamp
- total_price (Field2) — num
pay_methods (Untitled4)
- method_id (Key) — serial — Primary key — NOT NULL
- method_name (Field) — varchar(50)
price (Untitled5)
- price_id (Key) — serial — Primary key — NOT NULL
- price (Field) — num
- tax (Field2) — num
- is_annual (Field3) — boolean
ps-method (Untitled3)
- psm_id (Key) — serial — Primary key — NOT NULL
- ps_id (Key2) — serial — Foreign key → pay_histories.ps_id — NOT NULL
- tenant_id (Key22) — serial — Foreign key → pay_histories.tenant_id — NOT NULL
- method_id (Key3) — serial — Foreign key → pay_methods.method_id — NOT NULL
ps_prices (Untitled6)
- psp_id (Key) — serial — Primary key — NOT NULL
- ps_id (Key2) — serial — Foreign key → pay_histories.ps_id — NOT NULL
- tenant_id (Key22) — serial — Foreign key → pay_histories.tenant_id — NOT NULL
- price_id (Key3) — serial — Foreign key → price.price_id — NOT NULL