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