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