fitness

Tables (4)

Department (departments)

  • id (department_id) — BIGINT — Primary key — NOT NULL
  • Field

DepositLog (deposit_logs)

  • id (deposit_log_id) — BIGINT — Primary key — NOT NULL
  • member (FK_member_deposit_logs_members) — BIGINT — Foreign key → Member.id — NOT NULL
  • createdAt (created_at) — TIMESTAMP
  • amount — DOUBLE
  • unit — VARCHAR(16)

Member (members)

  • id (member_id) — BIGINT — Primary key — NOT NULL
  • studentNumber (student_number) — VARCHAR(16)
  • uuid (member_uuid) — VARCHAR(16)
  • name — VARCHAR(16)
  • birthDate (birth_date) — DATETIME
  • workoutLevel (workout_level) — VARCHAR(64)
  • createdAt (created_at) — TIMESTAMP
  • grade — VARCHAR(64)
  • department (FK_department_members_departments) — BIGINT — Foreign key → Department.id — NOT NULL

RequestStatus (request_statuses)

  • id (request_status_id) — BIGINT — Primary key — NOT NULL
  • action (request_action) — VARCHAR(64)
  • member (FK_member_request_statuses_members) — BIGINT — Foreign key → Member.id — NOT NULL
  • createdAt (created_at) — TIMESTAMP