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