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