Gym_Management_APP
Tables (6)
ENROLLMENT (ENROLLMENTS)
- ID (ENROLLMENT_ID) — NUMBER — Primary key — NOT NULL
- ID (MEMBER_ID) — NUMBER — Foreign key → MEMBER.ID — NOT NULL
- ID (MEMBERSHIP_TYPE_ID) — NUMBER — Foreign key → MEMBERSHIP_TYPE.ID — NOT NULL
- 시작일 (START_DATE) — DATE
- 연장일수 (INACTIVE) — NUMBER
ENTRY_LOG (ENTRY_LOGS)
- ENTRY_ID — NUMBER — Primary key — NOT NULL
- ID (MEMBER_ID) — NUMBER — Foreign key → MEMBER.ID — NOT NULL
- 입장시각 (ENTRY_TIME) — SYSTIMESTAMP
- 퇴장시각 (EXIT_TIME) — SYSTIMESTAMP
MEMBER (MEMBERS)
- ID (MEMBER_ID) — NUMBER — Primary key — NOT NULL
- 이름 (NAME) — VARCHAR2(100)
- 성별 (GENDER) — VARCHAR2(10)
- 생년월일 (BIRTHDATE) — DATE
- 휴대전화 (PHONE_NUMBER) — VARCHAR2(10)
- 회원등록일 (JOIN_DATE) — DATE
- 회원주소 (ADDRESS) — VARCHAR2(255) — NOT NULL
- 메모 내용 (MEMO) — VARCHAR2(255)
- 메모 수정일 (MEMO_MDATE) — DATE
MEMBERSHIP_TYPE (MEMBERSHIP_TYPES)
- ID (MEMBERSHIP_TYPE_ID) — NUMBER — Primary key — NOT NULL
- 유형이름 (TYPE_NAME) — VARCHAR2(50)
- 유형번호 (TYPE_NUM) — NUMBER
MEMBERSHIP_TYPE_DETAIL (MEMBERSHIP_TYPE_DETAILS)
- ID (MEMBERSHIP_TYPE_DETAIL_ID) — NUMBER — Primary key — NOT NULL
- ID (MEMBERSHIP_TYPE_ID) — NUMBER — Foreign key → MEMBERSHIP_TYPE.ID — NOT NULL
- 상세 키 (DETAIL_NAME) — VARCHAR2(50)
- 상세 값 (DETAIL_VALUE) — VARCHAR2(255)
USER (USERS)
- ID — NUMBER — Primary key — NOT NULL
- login id (USERNAME) — VARCHAR2(50)
- password (PASSWORD) — VARCHAR2(50)
- role (ROLE) — VARCHAR2(50)