dallaem

Tables (11)

Comments (Untitled9)

  • ID (comment_id) — UUID — Primary key — NOT NULL
  • 내용 (content) — TEXT
  • 생성일자 (created_at) — TIMESTAMP
  • 수정일자 (updated_at) — TIMESTAMP
  • ID (post_id) — UUID — Foreign key → Posts.ID — NOT NULL
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL — 작성자id

Favorites (Untitled7)

  • ID (facoriate_id) — UUID — Primary key — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL
  • ID (metting_id) — UUID — Foreign key → meetings.ID — NOT NULL

Posts (Untitled8)

  • ID (post_id) — UUID — Primary key — NOT NULL
  • 제목 (title) — VARCHAR — NOT NULL
  • 내용 (content) — TEXT
  • 이미지 (imate_url) — VARCHAR
  • 조회수 (view_count) — INT
  • 좋아요수 (like_count) — INT
  • 생성일자 (created_at) — TIMESTAMP
  • tnwjddlfwk (updated_at) — TIMESTAMP
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL — 작성자id

Refresh_tokens (Untitled3)

  • ID (token_id) — UUID — Primary key — NOT NULL
  • token_hash — VARCHAR
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP — refresh시 기존 토큰 무효화
  • created_at — NOT NULL
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL

Reviews (Untitled6)

  • ID (review_id) — UUID — Primary key — NOT NULL
  • 점수 (score) — INT — NOT NULL — 1<= <=5
  • 리뷰내용 (comment) — TEXT
  • 생성일자 (created_at) — TIMESTAMP
  • 수정일자 (updated_at) — TIMESTAMP
  • ID (metting_id) — UUID — Foreign key → meetings.ID — NOT NULL
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL

meeting_participants (Untitled5)

  • ID (participant_id) — UUID — Primary key — NOT NULL
  • Field
  • ID (metting_id) — UUID — Foreign key → meetings.ID — NOT NULL
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL
  • 참여시각 (joined_at) — TIMEATAMP

meetings (Untitled4)

  • ID (metting_id) — INT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR — NOT NULL
  • type — VARCHAR
  • 지역 (region) — VARCHAR
  • 주소 (address) — VARCHAR
  • 위도 (latitude) — FLOAT
  • 경도 (longitude) — FLOAT
  • 모임일자 (date_time) — TIMESTAMP — NOT NULL
  • 모집 마감일 (registration_end) — TIMESTAMP — <date_time
  • 인원수 (capacity) — INT — NOT NULL — 1<= <=1000
  • 참여자수 (participant_count) — INT
  • 이미지 (image_url) — VARCHAR
  • 설명 (description) — TEXT
  • 취소시간 (canceled_at) — TIMESTAMP
  • 최소인원 도달 시간 (confirmed_at) — TIMESTAMP — 5명 도달 시
  • 생성시간 (created_at) — TIMESTAMP — NOT NULL
  • 수정시간 (updated_At) — TIMESTAMP — NOT NULL
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL — 주최자ID
  • ?? (created_by)

notifications (Untitled11)

  • ID (notification_id) — UUID — Primary key — NOT NULL
  • 타입 (type) — VARCHAR — 미팅확인,미팅취소,댓글
  • 메시지 (message) — VARCHAR
  • 데이터 (Field) — JSONB — meetingId,meetingName,postId,postTitle,commentId,image
  • 읽음유무 (is_read) — BOOLEAN
  • 생성일자 (created_at) — TIMESTAMP
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL

post_likes (Untitled10)

  • ID (like_id) — UUID — Primary key — NOT NULL
  • 생성일자 (created_at) — TIMESTAMP
  • ID (post_id) — UUID — Foreign key → Posts.ID — NOT NULL
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL

user_oauth_accounts (Untitled2)

  • ID (oauth_id) — UUID — Primary key — NOT NULL
  • provider — ENUM — UQ
  • 서브id (provider_user_id) — VARCHAR
  • 생성시간 (created_at) — TIMESTAMP — NOT NULL
  • ID (user_id) — UUID — Foreign key → users.ID — NOT NULL

users (Untitled)

  • ID (user_id) — UUID — Primary key — NOT NULL
  • email — VARCHAR — NOT NULL — UQ
  • 비밀번호 (password) — VARCHAR — NOT NULL
  • 이름 (name) — VARCHAR — NOT NULL — 길이>=1,길이<=20
  • 회사이름 (company_name) — VARCHAR — 길이<=50
  • 프로필 (image_url) — VARCHAR
  • 생성시간 (created_at) — TIMESTAMP — NOT NULL
  • 수정시간 (updated_at) — TIMESTAMP