하단져스
테이블 (7)
account_types (Untitled4)
- account_type_id (Key) — 기본 키 — NOT NULL
- account_type_name (Field2)
accounts (Untitled3)
- account_id (Key) — 기본 키 — NOT NULL
- account_number (Field2)
- money (Field)
- interest_rate (Field3)
- created_at (Field4)
- saving_start (Field6)
- saving_end (Field7)
- member_id (Key2) — 외래 키 → members.member_id — NOT NULL
- bank_id (Key3) — 외래 키 → banks.bank_id — NOT NULL
- account_type_id (Key4) — 외래 키 → account_types.account_type_id — NOT NULL
banks (Untitled2)
- bank_id (Key) — 기본 키 — NOT NULL
- bank_name (Field)
game_results (Untitled7)
- result_id (Key) — 기본 키 — NOT NULL
- score (Field)
- member_id (Key2) — 외래 키 → members.member_id — NOT NULL
health_data (Untitled6)
- health_data_id (Key) — 기본 키 — NOT NULL
- heart_rate (Field)
- oxygen_saturation (Field2)
- sleep (Field3)
- sleep_stage (Field4)
- blood_pressure (Field5)
- stress (Field6)
- member_id (Key2) — 외래 키 → members.member_id — NOT NULL
members (Untitled)
- member_id (Key) — 기본 키 — NOT NULL
- member_info (Field)
- password (Field2)
- fingerprint (Field3)
- registered_at (Field4)
transfer_details (Untitled5)
- transfer_id (Key) — 기본 키 — NOT NULL
- money (Field)
- sender_id (Key4) — 외래 키 → members.member_id — NOT NULL
- reciver_id (Key3) — 외래 키 → members.member_id — NOT NULL
- sender_account_id (Key2) — 외래 키 → accounts.account_id — NOT NULL
- reciver_account_id (Key5) — 외래 키 → accounts.account_id — NOT NULL