토이프로젝트-운동일지
테이블 (3)
exerciseType (EXERCISE_TYPE)
- id (ID) — BIGSERIAL — 기본 키 — NOT NULL
- code (CODE) — SMALLINT
- name (NAME) — VARCHAR(100)
- category (CATEGORY) — VARCHAR(50)
- dateCreated (DATE_CREATED) — TIMESTAMP
- lastUpdated (LAST_UPDATED) — TIMESTAMP
- lastUpdator (LAST_UPDATOR) — BIGINT
user (USER)
- id (ID) — BIGSERIAL — 기본 키 — NOT NULL
- userId (USER_ID) — VARCHAR(50)
- password (PASSWORD) — VARCHAR(50)
- dateCreated (DATE_CREATED) — TIMESTAMP
- lastUpdated (LAST_UPDATED) — TIMESTAMP
- lastUpdator (LAST_UPDATOR) — BIGINT
workoutLog (WORKOUT_LOG)
- id (ID) — BIGSERIAL — 기본 키 — NOT NULL
- userId (USER_ID) — BIGSERIAL — 외래 키 → user.id — NOT NULL
- exerciseTypeId (EXERCISE_TYPE_ID) — BIGSERIAL — 외래 키 → exerciseType.id — NOT NULL
- setNumber (SET_NUMBER) — SMALLINT
- weight (WEIGHT) — FLOAT
- repetitions (REPETITIONS) — SMALLINT
- memo (MEMO) — TEXT
- dateCreated (DATE_CREATED) — TIMESTAMP
- lastUpdated (LAST_UPDATED) — TIMESTAMP
- lastUpdator (LAST_UPDATOR) — BIGINT