bank
Tables (7)
Card(work)
- Key (Card_ID) — INT(16) — Primary key — NOT NULL
- Field (Card_creation_date) — DATE
- Field2 (Card_limit_amount) — INT(7)
- Field (Card_payment_date) — DATE
- Field3 (Card_type) — VARCHAR(255)
- FK (Customer_number) — INT(13) — NOT NULL
- FK2 (Deposit_amount_ID) — INT(16) — NOT NULL
Card_using
- Key (Card_ID) — INT(16) — Foreign key → Card(work).Key — NOT NULL
- PK (Deposit_amount_ID) — INT(16) — Foreign key → Deposit_amount.PK — NOT NULL
- PK (Deposit_amount_ID2) — INT(16) — Foreign key → Deposit_amount.PK — NOT NULL
- PK2 (Deposit_withdrawl_date) — DATE — Foreign key → Deposit_amount.PK2 — NOT NULL
- PK3 (Transaction_number) — INT — Foreign key → Deposit_amount.PK3 — NOT NULL
Customer
- PK (Customer_number) — INT(13) — Primary key — NOT NULL
- FK (Custotmer_name) — VARCHAR(255)
- Field2 (Customer_address) — VARCHAR(255)
- Field3 (Customer_birth) — DATE
- Field4 (Customer_phone) — VARCHAR(11)
- Field5 (Customer_job) — VARCHAR(255)
Deposit_amount
- PK (Deposit_amount_ID) — INT(16) — Primary key — NOT NULL
- PK (Deposit_amount_ID2) — INT(16) — Foreign key → transaction_detail.PK — NOT NULL
- PK2 (Deposit_withdrawl_date) — DATE — Foreign key → transaction_detail.PK2 — NOT NULL
- PK3 (Transaction_number) — INT — Foreign key → transaction_detail.PK3 — NOT NULL
- Field (Deposit_amount_type) — VARCHAR(255)
- FK (Deposit_balance) — INT(15) — NOT NULL
- Field2 (Card_apply_status) — BOOL
- Field3 (Deposit_open_date) — DATE
- FK2 (Customer_name) — VARCHAR(255)
- Field5 (Customer_phone) — NUMBER(11)
- Field (e-mail) — VARCHAR(255)
- FK3 (Customer_number) — INT(13) — NOT NULL
Deposit_amount_open
- PK (Customer_number) — INT(13) — Foreign key → Customer.PK — NOT NULL
- PK (Deposit_amount_ID) — INT(16) — Foreign key → Deposit_amount.PK — NOT NULL
- PK (Deposit_amount_ID2) — INT(16) — Foreign key → Deposit_amount.PK — NOT NULL
- PK2 (Deposit_withdrawl_date) — DATE — Foreign key → Deposit_amount.PK2 — NOT NULL
- PK3 (Transaction_number) — INT — Foreign key → Deposit_amount.PK3 — NOT NULL
Deposit_amount_transaction_details
- PK (Deposit_amount_ID) — INT(16) — Primary key — NOT NULL
- PK2 (Deposit_withdrawl_date) — DATE — Primary key — NOT NULL
- PK3 (Transaction_number) — INT — Primary key — NOT NULL
- Field (Deposit_class) — VARCHAR(255)
- Field2 (Deposit_detail) — VARCHAR(255)
- Field3 (Transaction_amount) — INT
- FK (Deposit_balance) — INT(15)
transaction_detail
- PK (Deposit_amount_ID) — INT(16) — Foreign key → Deposit_amount_transaction_details.PK — NOT NULL
- PK2 (Deposit_withdrawl_date) — DATE — Foreign key → Deposit_amount_transaction_details.PK2 — NOT NULL
- PK3 (Transaction_number) — INT — Foreign key → Deposit_amount_transaction_details.PK3 — NOT NULL