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