bank
Tables (12)
bank_california (Untitled4)
- branch_code (Key) — VAR — Primary key — NOT NULL
- Field
bank_gwangju (Untitled2)
- branch_code (Key) — VAR — Primary key — NOT NULL
- Field
bank_newyork (Untitled3)
- account_num (Key) — VAR — Primary key — NOT NULL
- Field
bank_seoul (Untitled)
- branch_code (Key) — VAR — Primary key — NOT NULL
- Field
custom_alice (10)
- account_num (Key) — VAR — Primary key — NOT NULL
- account_name (Field) — VAR
- Field2
- branch_code (Key2) — VAR — Foreign key → bank_california.branch_code — NOT NULL
custom_chulsu (5)
- account_num (Key) — VAR — Primary key — NOT NULL
- account_name (Field) — VAR
- Field2
- branch_code (Key2) — VAR — Foreign key → bank_seoul.branch_code — NOT NULL
custom_jack (9)
- account_num (Key) — VAR — Primary key — NOT NULL
- account_name (Field) — VAR
- Field2
- branch_code (Key3) — VAR — Foreign key → bank_california.branch_code — NOT NULL
custom_kevin (7)
- account_num (Key) — VAR — Primary key — NOT NULL
- account_name (Field) — VAR
- Field2
- account_num (Key2) — VAR — Foreign key → bank_newyork.account_num — NOT NULL
custom_sohee (6)
- account_num (Key) — VAR — Primary key — NOT NULL
- account_name (Field) — VAR
- Field2
- branch_code (Key2) — VAR — Foreign key → bank_seoul.branch_code — NOT NULL
custom_youngsoo (8)
- account_num (Key) — VAR — Primary key — NOT NULL
- account_name (Field) — VAR
- Field2
- branch_code (Key2) — VAR — Foreign key → bank_gwangju.branch_code — NOT NULL
product_loans (대출)
- product_code (Key) — VAR — Primary key — NOT NULL
- account (Key2) — VAR — Primary key — NOT NULL
- account_num (Key3) — VAR — Foreign key → custom_sohee.account_num — NOT NULL
- account_num (Key4) — VAR — Foreign key → custom_youngsoo.account_num — NOT NULL
- account_num (Key5) — VAR — Foreign key → custom_kevin.account_num — NOT NULL
- account_num (Key6) — VAR — Foreign key → custom_jack.account_num — NOT NULL
- branch_code (Key7) — VAR — Foreign key → bank_seoul.branch_code — NOT NULL
- branch_code (Key8) — VAR — Foreign key → bank_gwangju.branch_code — NOT NULL
- account_num (Key9) — VAR — Foreign key → bank_newyork.account_num — NOT NULL
- branch_code (Key10) — VAR — Foreign key → bank_california.branch_code — NOT NULL
- create_date (Field) — VAR
- expiry_date (Field2) — VAR
product_saving (예금)
- product_code (Key) — VAR — Primary key — NOT NULL
- account (Key2) — VAR — Primary key — NOT NULL
- account_num (Key3) — VAR — Foreign key → custom_chulsu.account_num — NOT NULL
- account_num (Key4) — VAR — Foreign key → custom_sohee.account_num — NOT NULL
- account_num (Key5) — VAR — Foreign key → custom_kevin.account_num — NOT NULL
- account_num (Key6) — VAR — Foreign key → custom_alice.account_num — NOT NULL
- account_num (Key7) — VAR — Foreign key → custom_jack.account_num — NOT NULL
- branch_code (Key8) — VAR — Foreign key → bank_seoul.branch_code — NOT NULL
- branch_code (Key9) — VAR — Foreign key → bank_gwangju.branch_code — NOT NULL
- account_num (Key10) — VAR — Foreign key → bank_newyork.account_num — NOT NULL
- branch_code (Key11) — VAR — Foreign key → bank_california.branch_code — NOT NULL
- create_date (Field) — VAR
- expiry_date (Field2) — VAR