하단져스

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