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