fitmotion

Tables (4)

ChatMessage (Untitled4)

  • 식별자 (id) — Primary key — NOT NULL
  • 식별자 (chat_room_id) — Foreign key → ChatRoom.식별자 — NOT NULL
  • 내용 (content)
  • 생성일 (created_at)
  • 식별자 (member_id) — Foreign key → Member.식별자 — NOT NULL

ChatRoom (Untitled3)

  • 식별자 (id) — Primary key — NOT NULL
  • 식별자 (coaching_request_id) — Foreign key → CoachingRequest.식별자 — NOT NULL
  • 생성일 (created_at)

CoachingRequest (Untitled2)

  • 식별자 (id) — Primary key — NOT NULL
  • 상태 (status) — enum
  • 생성일 (created_at)
  • 식별자 (member_id) — Foreign key → Member.식별자 — NOT NULL
  • 식별자 (trainer_id) — Foreign key → Member.식별자 — NOT NULL

Member (Untitled)

  • 식별자 (id) — Primary key — NOT NULL
  • 이름 (name)
  • 역할 (type) — enum