newple
Tables (8)
ExerciseStyle (운동스타일)
- Key (id) — bigint — Primary key — NOT NULL
- Key (style_id) — bigint — Foreign key → Profile.Key — NOT NULL
- Field (value) — varchar
Interests (관심사)
- Key (id) — bigint — Primary key — NOT NULL
- Key (interest_id) — bigint — Foreign key → Profile.Key — NOT NULL
- Field (value) — varchar
Match (매칭)
- Key (id) — bigint — Primary key — NOT NULL
- Key (applicant_id) — bigint — Foreign key → Member.Key — NOT NULL
- Key (applicationi_post_id) — bigint — Foreign key → Post.Key — NOT NULL
- Field (match_status) — varchar
Member (회원)
- Key (member_id) — bigint — Primary key — NOT NULL
Message (쪽지)
- Key (message_id) — bigint — Primary key — NOT NULL
- Key (sender_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (receiver_id) — bigint
- Field (content) — varchar
- Field (sent_date) — timestamp
Post (게시글)
- Key (post_id) — bigint — Primary key — NOT NULL
- Key (writer_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (content) — varchar
- Field (region_name) — varchar
- Field (sport) — varchar
- Field (status) — varchar
- Field (title) — varchar
- Field (age) — varchar
- Field (gender) — varchar
- Field (runtime) — String
- Field (written_date) — timestamp
PostTag (게시글태그)
- Key (id) — Long — Primary key — NOT NULL
- Key (post_tag_id) — Long — Foreign key → Post.Key — NOT NULL
- Field (tag) — varchar
Profile (프로필)
- Key (profile_id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Member.Key — NOT NULL
- Field (profile_img) — varchar