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