미수금

테이블 (6)

crm (product_price)

  • Key (seq_product_price) — int — 기본 키 — NOT NULL
  • Field (price) — int
  • Field (begin_dt) — datetime
  • Field (end_dt) — datetime
  • Field (created_dt) — datetime
  • seq_product (seq_product2) — int — 외래 키 → crm.seq_product — NOT NULL

crm (partner)

  • Key (seq_partner) — int — 기본 키 — NOT NULL
  • seq_product — int — 외래 키 → crm.seq_product — NOT NULL
  • Field (total_receivable) — int
  • Field (receivable_dt) — datetime
  • Field (contract_dt) — datetime
  • Field (payment_status) — varchar
  • Field (use_yn) — varchar(1)

crm (product)

  • seq_product — int — 기본 키 — NOT NULL
  • Field (payment_type) — int
  • Field (agreement_type) — varchar
  • Field (created_dt) — datetime
  • Field (updated_dt) — datetime

crm (partner_invoice)

  • Key (seq_partner_invoice) — int — 기본 키 — NOT NULL
  • Field (price) — int
  • Field (pay_amount) — int
  • Field (status) — varchar
  • Field (issue_dt) — datetime
  • Field (payment_dt) — datetime
  • Field (invoice_title) — varchar(500)
  • Key (seq_product_price) — int — 외래 키 → crm.Key — NOT NULL
  • Key (seq_partner2) — int — 외래 키 → crm.Key — NOT NULL

crm (adjustment_record)

  • Key (seq_adjustment_record) — int — 기본 키 — NOT NULL
  • Field (register_id) — int
  • Field (amount) — int
  • Field (status) — varchar
  • Field (payment_dt) — datetime
  • Field (created_dt) — datetime
  • Key (seq_partner) — int — 외래 키 → crm.Key — NOT NULL

crm (adjustment_file)

  • Key (seq_adjustment_file) — int — 기본 키 — NOT NULL
  • Field (path) — varchar
  • Field (created_dt) — datetime