BANK
Tables (4)
B_Acc_Trades (Untitled4)
- imp_exp_date (Key) — DATE — Primary key
- trade_id (Key2) — NUMBER(10) — Primary key
- acc_id (Key4) — VARCHAR2(10) — Foreign key → B_Accounts.acc_id
- acc_class (Field) — VARCHAR2(20)
- acc_contents (Field2) — VARCHAR2(50)
- trade_money (Field3) — NUMBER
- acc_balance (Field4) — NUMBER(10) — NOT NULL
B_Accounts (Untitled3)
- acc_id (Key) — VARCHAR2(10) — Primary key
- cust_jumin (Key2) — VARCHAR2(20) — Foreign key → B_Customers.cust_jumin — NOT NULL
- acc_type (Field) — VARCHAR2(20) — NOT NULL
- acc_balance (Field2) — NUMBER(10) — NOT NULL
- card_ask (Field3) — VARCHAR2(5) — NOT NULL
- acc_register_date (Field4) — DATE
- add_cust_name (Field5) — VARCHAR2(20) — NOT NULL
- add_phnum (Field6) — VARCHAR2(20)
- acc_email (Field7) — VARCHAR2(50) — NOT NULL
B_Cards (Untitled2)
- card_id (Key) — VARCHAR2(15) — Primary key — NOT NULL
- cust_jumin (Key2) — VARCHAR2(20) — Foreign key → B_Customers.cust_jumin — NOT NULL
- acc_id (Key3) — VARCHAR2(10) — Foreign key → B_Accounts.acc_id
- card_register_date (Field) — DATE
- card_limit_money (Field2) — NUMBER(10)
- card_approve_date (Field3) — DATE
- card_type (Field4) — VARCHAR2(10) — NOT NULL
B_Customers (Untitled)
- cust_jumin (Key) — VARCHAR2(20) — Primary key — NOT NULL
- cust_name (Field) — VARCHAR2(20) — NOT NULL
- cust_addr (Field2) — VARCHAR2(100) — NOT NULL
- cust_birth (Field3) — DATE — NOT NULL
- cust_email (Field4) — VARCHAR2(50) — NOT NULL
- cust_phnum (Field5) — VARCHAR2(25) — NOT NULL
- cust_job (Field6) — VARCHAR2(30) — NOT NULL