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