IEUM

테이블 (14)

answers

  • answer_id — BIGSERIAL — 기본 키 — NOT NULL
  • question_id — BIGINT — 외래 키 → questions.question_id — NOT NULL
  • author_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • is_accepted — BOOLEAN — NOT NULL
  • embedding — vector(1536)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

chat_members

  • room_id — BIGINT — 외래 키 → chat_rooms.room_id — NOT NULL
  • user_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL
  • left_at — TIMESTAMPTZ
  • last_read_at — TIMESTAMPTZ

chat_rooms

  • room_id — BIGSERIAL — 기본 키 — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meetings.meeting_id
  • room_type — room_type — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

friendships

  • friendship_id — BIGSERIAL — 기본 키 — NOT NULL
  • requester_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • addressee_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • status — friendship_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_participants

  • meeting_id — BIGINT — 외래 키 → meetings.meeting_id — NOT NULL
  • user_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • status — participant_status — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL

meetings

  • meeting_id — BIGSERIAL — 기본 키 — NOT NULL
  • pin_id — BIGINT — 외래 키 → 핀.pin_id — NOT NULL
  • host_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • meeting_at — TIMESTAMPTZ — NOT NULL
  • max_members — SMALLINT — NOT NULL
  • icon — VARCHAR(50)
  • status — meeting_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

messages

  • message_id — BIGSERIAL — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → chat_rooms.room_id — NOT NULL
  • sender_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • content — TEXT
  • image_url — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

notifications

  • notification_id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • type — notification_type — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — TEXT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

question_images

  • image_id — BIGSERIAL — 기본 키 — NOT NULL
  • question_id — BIGINT — 외래 키 → questions.question_id — NOT NULL
  • image_url — TEXT — NOT NULL
  • sort_order — SMALLINT — NOT NULL

questions

  • question_id — BIGSERIAL — 기본 키 — NOT NULL
  • pin_id — BIGINT — 외래 키 → 핀.pin_id — NOT NULL
  • author_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • is_resolved — BOOLEAN — NOT NULL
  • embedding — vector(1536)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

reports

  • report_id — BIGSERIAL — 기본 키 — NOT NULL
  • reporter_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • message_id — BIGINT — 외래 키 → messages.message_id
  • reason — report_reason — NOT NULL
  • detail — TEXT
  • status — report_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

user_settings

  • user_id — BIGSERIAL — 외래 키 → 사용자.user_id — NOT NULL
  • language — VARCHAR(5) — NOT NULL
  • camera_permission — BOOLEAN — NOT NULL
  • push_permission — BOOLEAN — NOT NULL
  • notify_default — BOOLEAN — NOT NULL
  • notify_location — BOOLEAN — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

사용자 (users)

  • user_id — BIGSERIAL — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • provider — AUTH_PROVIDER — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • gender — gender_type
  • nationality — VARCHAR(2)
  • profile_image_url — TEXT
  • email_verified — BOOLEAN — NOT NULL
  • last_location (last_loaction) — GEOGRAPHY(POINT, 4326)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

핀 (pins)

  • pin_id — BIGSERIAL — 기본 키 — NOT NULL
  • author_id — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • pin_type — PIN_TYPE — NOT NULL
  • location — GEOGRAPHY(POINT, 4326) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ