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