토이프로젝트-운동일지

테이블 (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