실습

테이블 (4)

기구

  • machine_id (machine_Id) — number — 기본 키 — NOT NULL
  • machine_name — varchar2
  • machine_price — number
  • machine_manufacturer — varchar2
  • gym_id — number — 외래 키 → 헬스장.gym_id — NOT NULL

헬스장

  • gym_id — number — 기본 키 — NOT NULL
  • gym_name — varchar2
  • gym_location — varchar2
  • gym_email — varchar2
  • gym_phone — varchar2

회원

  • member_id — number — 기본 키 — NOT NULL
  • member_name — varchar2
  • member_age — number
  • member_phone — varchar2
  • ticket_id — number — 외래 키 → 회원권.ticket_id — NOT NULL

회원권

  • ticket_id — number — 기본 키 — NOT NULL
  • ticket_enroll_month — number
  • ticket_start_date — date
  • ticket_end_date — date
  • gym_id — number — 외래 키 → 헬스장.gym_id — NOT NULL