입금의정석

테이블 (5)

Customer (Untitled)

  • customer_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → User.user_id — NOT NULL
  • customer_description (Field5)
  • customer_name (Field2) — varchar — NOT NULL
  • expected_depositor_name (Field3) — varchar — NOT NULL — default = customer_name
  • car_number (Field4) — varchar
  • basic_payment (Field) — 기본 설정금액

Deposit (Untitled5)

  • deposit_id (Key) — int — 기본 키 — NOT NULL
  • deposit_time (Field) — datetime — NOT NULL
  • depositor_name (Field2) — varchar — NOT NULL
  • deposit_amount (Field3) — NOT NULL

Deposit_transaction (Untitled4)

  • deposit_id (Key2) — int — 외래 키 → Deposit.deposit_id — NOT NULL
  • transaction_id (Key) — int — 외래 키 → transaction.transaction_id — NOT NULL

User (Untitled2)

  • user_id (Key) — int — 기본 키 — NOT NULL
  • create_time (Field) — datetime — NOT NULL

transaction (Untitled3)

  • transaction_id (Key) — int — 기본 키 — NOT NULL
  • add_payment (Field)
  • trasaction_memo (Field2)
  • customer_id (Key2) — int — 외래 키 → Customer.customer_id — NOT NULL
  • yearmonth (Field3) — NOT NULL