MateTrip_ERD
Tables (18)
Follow
- id — UUID — Primary key — NOT NULL — PK
- follower_id — UUID — Foreign key → users.id — NOT NULL — FK
- following_id — UUID — Foreign key → users.id — NOT NULL — FK
- created_at — TIMESTAMPTZ — NOT NULL
Notification
- Key — UUID — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users.id — NOT NULL — FK
- content — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- confirmed — Boolean — NOT NULL
binary_content
- id — UUID — Primary key — NOT NULL — PK
- created_at — TIMESTAMPTZ — NOT NULL
- file_name — TEXT — NOT NULL
- file_type — TEXT — NOT NULL
- file_size — BIGINT — NOT NULL
chat_message
- id — UUID — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users.id — NOT NULL — FK
- workspace_id — UUID — Foreign key → workspace.id — NOT NULL — FK
- create_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- content — TEXT — NOT NULL
place
- id — UUID — Primary key — NOT NULL — PK
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- title — TEXT — NOT NULL
- address — TEXT — NOT NULL
- categories — JSONB — NOT NULL
- tags — JSONB — NOT NULL
- summary — TEXT
- longitude — FLOAT — NOT NULL
- latitude — FLOAT — NOT NULL
- embedding — VECTOR(1024)
- location — GEOGRAPHY(POINT, 4326) — 공간인덱싱용
- sido — TEXT — NOT NULL
place_review
- id — UUID — Primary key — NOT NULL — PK
- place_id — UUID — Foreign key → place.id — NOT NULL — PK
- created_at — TIMESTAMPTZ — NOT NULL
- content — JSON — NOT NULL
- source_url — TEXT — NOT NULL
- embedding — VECTOR(1024) — NOT NULL
place_user_review
- Key — UUID — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users.id — FK
- place_id — UUID — Foreign key → place.id — NOT NULL — FK
- content — TEXT
- rating — NUMERIC(10, 1) — NOT NULL — 1~5
- created_at — TIMETAMPTZ — NOT NULL
plan_day
- id — UUID — Primary key — NOT NULL — PK
- workspace_id — UUID — Foreign key → workspace.id — NOT NULL — FK, ON DELETE CASCADE
- created_at — TIMESTAMPTZ — NOT NULL
- day_no — INT — NOT NULL — >= 1
- plan_date — DATE
poi
- id — UUID — Primary key — NOT NULL — PK
- plan_day_id — UUID — Foreign key → plan_day.id — NOT NULL — FK(이거 필수로 안할까?)
- created_by — UUID — Foreign key → users.id — FK
- place_id — UUID — Foreign key → place.id — FK
- created_at — TIMESTAMPTZ — NOT NULL
- place_name — TEXT — NOT NULL
- longitude — DOUBLE — NOT NULL — Between -180 AND 180
- latitude — DOUBLE — NOT NULL — Between -90 AND 90
- address — TEXT — NOT NULL
- status — POI_STATUS — NOT NULL — ENUM(MARKED, SCHEDULED)
- sequence — INT — NOT NULL — plan_day_id내 스케쥴 순서
poi_connection
- id — UUID — Primary key — NOT NULL — PK
- distance — INT — NOT NULL — >= 0
- duration — INT — NOT NULL — >= 0
- created_at — TIMESTAMPTZ — NOT NULL
post
- id — UUID — Primary key — NOT NULL — PK
- writer_id — UUID — Foreign key → users.id — NOT NULL — FK
- image_id — UUID — Foreign key → binary_content.id — NOT NULL — FK
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- status — TEXT — NOT NULL — ENUM(모집중, 완료)
- location — TEXT — NOT NULL — 하드TEXT할지는 나중에
- keywords — TEXT — ENUM 리스트
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- max_people — INT — NOT NULL
post_participation
- id — UUID — Primary key — NOT NULL — PK
- requester_id — UUID — Foreign key → users.id — NOT NULL — FK
- post_id — UUID — Foreign key → post.id — NOT NULL — FK
- requested_at — TIMESTAMPTZ — NOT NULL
- status — TEXT — NOT NULL — ENUM(대기, 승인, 거절)
profile
- id — UUID — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users.id — NOT NULL — FK, UNIQUE
- profile_image_id — UUID — Foreign key → binary_content.id — NOT NULL — FK
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- nickname — TEXT — NOT NULL
- gender — TEXT — NOT NULL — ENUM(FEMALE, MALE)
- intro — TEXT — NOT NULL
- description — TEXT — NOT NULL
- travel_styles — travel_style_type — ENUM 리스트 (RELAXED: 휴식형, ADVENTUROUS: 액티비티형,...)
- travel-tendency — travel_tendency_type — ENUM 리스트 ()
- mbti — mbti_type — NOT NULL — ENUM 리스트 (INTJ, ENFP, )
- is_pass_auth — BOOLEAN — NOT NULL
- manner_temperatur — NUMERIC(4, 1) — NOT NULL
- profile_embedding — VECTOR(1024) — NOT NULL
review
- id — UUID — Primary key — NOT NULL
- post_id — UUID — Foreign key → post.id — FK, SET NULL
- reviewer_id — UUID — Foreign key → users.id — NOT NULL — FK
- reviewee_id — UUID — Foreign key → users.id — NOT NULL — FK
- created_at — TIMESTAMP — NOT NULL
- rating — NUMERIC(10, 1) — NOT NULL — 0~5
- content — TEXT — NOT NULL
user_behavior_embeddings
- id — UUID — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users.id — NOT NULL — FK
- behavior_embedding — VECTOR(1024)
- aggregated_data — JSONB
- total_events_count — INTEGER — NOT NULL
- last_updated — TIMESTAMPTZ — NOT NULL
user_behavior_events
- id — UUID — Primary key — NOT NULL — PK
- user_id — UUID — Foreign key → users.id — NOT NULL — FK
- workspace_id — UUID — Foreign key → workspace.id — FK
- place_id — UUID — Foreign key → place.id — FK
- plan_day_id — UUID — Foreign key → plan_day.id — FK
- event_type — TEXT — NOT NULL — 마킹, 언마킹, 스케쥴추가, 스케쥴제거
- weight — NUMERIC(5, 2) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
users
- id — UUID — Primary key — NOT NULL — PK
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ
- email — TEXT — NOT NULL — UNIQUE
- hashed_password — TEXT — NOT NULL
workspace
- id — UUID — Primary key — NOT NULL — PK
- post_id — UUID — Foreign key → post.id — NOT NULL — FK, UNIQUE
- workspace_name — TEXT — NOT NULL
- memo — TEXT