gym member

Tables (5)

MEMBER

  • MEMBER_ID — NUMBER(8)
  • NAME — VARCHAR2(50) — NOT NULL
  • BIRTH_DATE — DATE
  • EMAIL — VARCHAR2(100)
  • JOIN_DATE — DATE
  • GRADE_ID — NUMBER(3)
  • VISIT_COUNT — NUMBER(5)
  • LAST_VISIT_DATE — DATE

MEMBER_CONTACT

  • CONTACT_ID — NUMBER(8)
  • MEMBER_ID — NUMBER(8)
  • CONTACT_TYPE — VARCHAR2(20) — NOT NULL
  • CONTACT_VALUE — VARCHAR2(200) — NOT NULL

MEMBER_GRADE

  • GRADE_ID — NUMBER(3)
  • GRADE_NAME — VARCHAR2(20)
  • DESCRIPTION — VARCHAR2(200)

MEMBER_HISTORY

  • HISTORY_ID — NUMBER(8)
  • MEMBER_ID — NUMBER(8)
  • FIELD_NAME — VARCHAR2(50) — NOT NULL
  • OLD_VALUE — VARCHAR2(200)
  • NEW_VALUE — VARCHAR2(200)
  • CHANGE_DATE — DATE

VISIT_LOG

  • VISIT_ID — NUMBER(8)
  • MEMBER_ID — NUMBER(8)
  • CHECK_IN — DATE — NOT NULL
  • CHECK_OUT — DATE