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