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