실습

테이블 (5)

Accounts

  • account_id — number — 기본 키 — NOT NULL
  • customer_id — number
  • account_type — varchar2
  • balance — number
  • created_at — date
  • status — varchar2
  • customer_id (customer_id2) — number — 외래 키 → Customer_Info.customer_id — NOT NULL

Card_Management_History

  • history_id — number — 기본 키 — NOT NULL
  • card_id — number
  • action_type — varchar2
  • old_value — varchar2
  • new_value — varchar2
  • action_date — date
  • description — varchar2
  • card_id (card_id2) — number — 외래 키 → Cards.card_id — NOT NULL

Cards

  • card_id — number — 기본 키 — NOT NULL
  • card_number — varchar2
  • customer_id — number
  • account_id — number
  • card_type — varchar2
  • issued_date — date
  • expiry_date — date
  • status — varchar2
  • limit_amount — number
  • pin — varchar2
  • account_id (account_id2) — number — 외래 키 → Accounts.account_id — NOT NULL

Customer_Info

  • customer_id — number — 기본 키 — NOT NULL
  • full_name — varchar2 — NOT NULL
  • phone_number — varchar2 — NOT NULL
  • email — varchar2
  • address — varchar2
  • updated_at — date

Transactions

  • transaction_id — number — 기본 키 — NOT NULL
  • from_account_id — number
  • to_account_id — number
  • amount — number
  • transaction_type — varchar2
  • description — varchar2
  • transaction_date — date
  • card_id — number
  • account_id (account_id2) — number — 외래 키 → Accounts.account_id — NOT NULL