asdasd

Tables (8)

address

  • address_id — bigint — Primary key — NOT NULL
  • sido — varchar
  • sigungu — varchar
  • bname — varchar

comment

  • comment_id — bigint — Primary key — NOT NULL — PK
  • content — text
  • author_id — bigint — NOT NULL — FK
  • exercise_id — bigint — NOT NULL — FK

exercise

  • exercise_id — bigint — Primary key — NOT NULL — PK
  • host_id — bigint — NOT NULL — FK
  • participant_id — bigint — NOT NULL — FK
  • title — varchar
  • content — text
  • exerciseAt — datetime
  • endAt — datetime
  • gender_type — varchar — ALL, SAME
  • category — varchar — FITNESS, YOGA, CROSSFIT, RUNNING, SWIMMING, BADMINTON
  • status — varchar — ACTIVE, CLOSED
  • address_id — bigint — NOT NULL — FK

image

  • image_id — bigint — Primary key — NOT NULL — PK
  • filename — varchar
  • original_filename — varchar
  • remote_path — varchar
  • filesize — bigint
  • owner_id — bigint — NOT NULL — FK
  • profiled_member_id — bigint — NOT NULL — FK, UNI
  • exercise_id — bigint — NOT NULL — FK

member

  • member_id — bigint — Primary key — NOT NULL — PK
  • email — varchar — UNI
  • password — varchar
  • nickname — varchar — UNI
  • gender — varchar
  • address_id — bigint — NOT NULL — FK

proposal

  • proposal_id — bigint — Primary key — NOT NULL — PK
  • exercise_id — bigint — NOT NULL — FK, UNI2
  • participant_id — bigint — NOT NULL — FK, UNI2

reply

  • reply_id — bigint — Primary key — NOT NULL — PK
  • content — text
  • comment_id — bigint — NOT NULL — FK
  • author_id — bigint — NOT NULL — FK

review

  • review_id — bigint — Primary key — NOT NULL — PK
  • exercise_id — bigint — NOT NULL — FK, UNI3
  • src_member_id — bigint — NOT NULL — FK, UNI3
  • dest_member_id — bigint — NOT NULL — FK, UNI3
  • public_evaluation — int — -2 ~ 2
  • private_evalutaion — int — -2 ~ 2