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)