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