BANK

Tables (3)

Untitled (account_info)

  • Key (account_number) — varchar(50) — Primary key — NOT NULL
  • Key (customer_id) — varchar(50) — Foreign key → customer_info.Key — NOT NULL
  • Field (account_type) — varchar(50) — NOT NULL
  • Field2 (balance_final) — int — NOT NULL
  • Field3 (statement) — varchar(50) — NOT NULL
  • Field4 (new_date) — date — NOT NULL
  • Field (remove_date) — date

Untitled (trade_info)

  • Key (seq_number) — int — Primary key — NOT NULL
  • Key (account_number) — varchar(50) — Foreign key → Untitled.Key — NOT NULL
  • Field (trade_date) — date — NOT NULL
  • Field2 (content) — varchar(50) — NOT NULL
  • Field3 (in_out) — varchar(50) — NOT NULL
  • Field4 (money) — int — NOT NULL
  • Field5 (balance) — int — NOT NULL

customer_info

  • Key (customer_id) — varchar(50) — Primary key — NOT NULL
  • Field (customer_name) — varchar(50) — NOT NULL
  • Field2 (id_number) — varchar(50) — NOT NULL
  • Field3 (address) — varchar(50) — NOT NULL
  • Field (phone_number) — varchar(50) — NOT NULL