입금의정석
테이블 (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