bankProject

Tables (4)

B_ACCOUNTS (Untitled3)

  • acc_id (Key) — Not Null / Unique — Primary key — NOT NULL
  • cust_jumin (Key2) — Not Null / Unique — Foreign key → B_CUSTOMERS.cust_jumin — NOT NULL
  • acc_type (Field) — Not Null
  • acc_balance (Field2) — Not Null — NOT NULL
  • card_ask (Field3) — Not Null
  • acc_register_date (Field4)

B_ACC_TRADES (Untitled4)

  • imp_exp_date (Key) — Not Null / Unique — Primary key — NOT NULL
  • trade_id (Key2) — Not Null / Unique — Primary key — NOT NULL
  • acc_id (Key3) — Not Null / Unique — Foreign key → B_ACCOUNTS.acc_id — NOT NULL
  • cust_jumin (Key22) — Not Null / Unique — Foreign key → B_ACCOUNTS.cust_jumin — NOT NULL
  • acc_contents (Field2)
  • trade_money (Field3)
  • acc_balance (Field4) — Not Null

B_CARDS (Untitled2)

  • card_id (Key) — Not Null / Unique — Primary key — NOT NULL
  • acc_id (Key3) — Not Null / Unique — Foreign key → B_ACCOUNTS.acc_id — NOT NULL
  • cust_jumin (Key22) — Not Null / Unique — Foreign key → B_ACCOUNTS.cust_jumin — NOT NULL
  • card_register_date (Field3)
  • card_limit_money (Field4)
  • card_type (Field6) — Not Null

B_CUSTOMERS (Untitled)

  • cust_jumin (Key) — Not Null / Unique — Primary key — NOT NULL
  • cust_name (Field) — Not Null
  • cust_addr (Field2) — Not Null
  • cust_birth (Field3) — Not Null
  • cust_email (Field4) — Not Null
  • cust_phnum (Field5) — Not Null
  • cust_job (Field6) — NOT NULL