ROOM_FIT
Tables (5)
ROUTINE_MODEL (운동모델)
- MODEL_ID (모델_ID) — BIGINT — Primary key — NOT NULL
- TOTAL_POSE_CNT (총 자세 개수) — INT
- TOTAL_TIME (총 시간) — INT
ROUTINE_MODEL_POSE (운동모델자세)
- POSE_ID (운동모델자세_ID) — BIGINT — Primary key — NOT NULL
- MODEL_ID (모델_ID) — BIGINT — Foreign key → ROUTINE_MODEL.MODEL_ID — NOT NULL
- SEQ_NUM (순서번호) — INT
- POSE_DUR (자세 시간) — INT
- FILE_SOURCE (대표사진/영상) — VARCHAR
USER (사용자)
- USER_ID (사용자_ID) — BIGINT — Primary key — NOT NULL
- PASSWORD (비밀번호) — VARCHAR
USER_LOG (사용자 이력)
- USER_LOG_ID (사용자_이력_ID) — BIGINT — Primary key — NOT NULL
- START_TIME (운동시작시간) — DATETIME
- END_TIME (운동종료시간) — DATETIME
- USER_ID (사용자_ID) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
USER_ROUTINE_MODEL (사용자 운동모델)
- USER_MODEL_ID (사용자_운동모델_ID) — BIGINT — Primary key — NOT NULL
- USER_ID (사용자_ID) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- MODEL_ID (모델_ID2) — BIGINT — Foreign key → ROUTINE_MODEL.MODEL_ID — NOT NULL