실습
테이블 (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