owoonwan
Tables (7)
Group Member (모임멤버)
- participant_id (participant id) — LONG — Primary key — NOT NULL
- group _id (group id) — LONG — Foreign key → Wordout Group.group _id — NOT NULL
- user_id (user id) — String — Foreign key → Wordout Group.user_id — NOT NULL
- joined_at (join time) — Date
Post (게시글)
- post_id (post id) — LONG — Primary key — NOT NULL
- user_id (Key) — String — Foreign key → User.id — NOT NULL
- content (post content) — String
- created_at (create date) — Date
- updated_at (update date) — Date
- deleted_at (delete date) — Date
Post Comments (댓글)
- comment_id (comment id) — LONG — Primary key — NOT NULL
- post_id (post id2) — LONG — Foreign key → Post.post_id — NOT NULL
- user_id (Key) — String — Foreign key → Post.user_id — NOT NULL
- content (text content) — String
- created_at (create date) — Date
- updated_at (update date) — Date
- deleted_at (delete date) — Date
Post Media (미디어(사진,동영상))
- media_id (media id) — LONG — Primary key — NOT NULL
- post_id (post id) — LONG — Foreign key → Post.post_id — NOT NULL
- url (media url) — String
- type (media type) — String
- order (media order) — LONG
- created_at (create date) — Date
- deleted_at (delete date) — Date
Post likes (좋아요)
- like_id (like id) — LONG — Primary key — NOT NULL
- post_id (post id) — LONG — Foreign key → Post.post_id — NOT NULL
- user_id (Key) — String — Foreign key → Post.user_id — NOT NULL
- created_at (create date) — Date
- delete_at (delete date) — Date
User (사용자)
- id — LONG — Primary key — NOT NULL
- user_id (user id for login) — String
- password (password for login) — String
- nickname (user nickname) — String
- phoneNumber (user phoneNumber) — String
- created_at (create date) — Date
- updated_at (update date) — Date
- deleted_at (delete date) — Date
- role — String
Wordout Group (운동모임)
- group _id (group id) — LONG — Primary key — NOT NULL
- user_id (create user id) — String — Foreign key → User.id — NOT NULL
- max_participants (number of people) — LONG
- title (group title) — String
- description (group description) — String
- create_at (create date) — Date
- updated_at (update date) — Date
- status (group status) — String