final-project-8th

Tables (35)

Ad

  • id — bigint — Primary key — NOT NULL
  • event_id — bigint — NOT NULL
  • start_date — timestamptz — NOT NULL
  • end_date — timestamptz — NOT NULL
  • title — text — NOT NULL
  • content — text — NOT NULL

Ad (Untitled18)

  • ad_id (Key) — Primary key — NOT NULL
  • event_id (Key3) — Foreign key → Event.event_id — NOT NULL
  • ad_start_date (Field)
  • ad_end_date (Field2)
  • ad_title (Field3)
  • ad_content (Field4)

AnalysisNoti (Untitled16)

  • noti_id (Key) — Foreign key → Noti.noti_id — NOT NULL
  • target_sync (Field)

Chat

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • content — text — NOT NULL
  • by_bot — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL

Collection

  • id — bigint — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • type — text — NOT NULL

Collection (Untitled5)

  • collection_id (Key) — Primary key — NOT NULL
  • collection_name (Field)

CollectionMembership (Untitled6)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL
  • collection_id (Key2) — Foreign key → Collection.collection_id — NOT NULL
  • collection_type (Field2)
  • authority (Field)

CollectionMembership

  • user_id — bigint — NOT NULL
  • collection_id — bigint — NOT NULL
  • authority — text — NOT NULL

Content

  • id — bigint — Primary key — NOT NULL
  • type — text — Primary key — NOT NULL
  • name — text — NOT NULL
  • description — text — NOT NULL

Content (Untitled7)

  • content_id (Key) — Primary key — NOT NULL
  • content_type (Field3)
  • content_name (Field)
  • content_description (Field2)

Course

  • id — bigint — Foreign key → Content.id — NOT NULL
  • area — text — NOT NULL
  • schedule_start_date — timestamptz — NOT NULL
  • schedule_end_date — timestamptz — NOT NULL

Course (Untitled8)

  • course_id (Key) — Foreign key → Content.content_id — NOT NULL
  • course_area (Field)
  • course_schedule_start_date (Field2)
  • course_schedule_end_date (Field3)

CourseElement

  • course_id — bigint — Primary key — NOT NULL
  • sequence — integer — Primary key — NOT NULL
  • content_id — bigint — NOT NULL
  • content_type — text — NOT NULL

CourseElement (Untitled10)

  • course_element_id (Key) — Primary key — NOT NULL
  • course_id (Key3) — Foreign key → Course.course_id — NOT NULL
  • target_id (Key32) — Foreign key → VisitTarget.target_id — NOT NULL
  • course_sequence (Field)

Event

  • id — bigint — Foreign key → Content.id — NOT NULL
  • image_id — bigint
  • place_id — bigint — NOT NULL
  • start_date — timestamptz — NOT NULL
  • end_date — timestamptz — NOT NULL
  • type — text — NOT NULL

Event (Untitled3)

  • event_id (Key3) — Foreign key → VisitTarget.target_id — NOT NULL
  • image_id (Key2) — Foreign key → Image.image_id — NOT NULL
  • event_start_date (Field)
  • event_end_date (Field2)
  • event_type (Field3)
  • place_id (Key32) — Foreign key → Place.place_id — NOT NULL

EventNoti (Untitled15)

  • noti_id (Key) — Foreign key → Noti.noti_id — NOT NULL
  • target_event_id (Key3) — Foreign key → Event.event_id — NOT NULL

Image

  • id — bigint — Primary key — NOT NULL
  • type — text — NOT NULL
  • url — text — NOT NULL

Image (Untitled9)

  • image_id (Key) — Primary key — NOT NULL
  • image_type (Field)
  • image_url (Field2)

Invitation

  • id — bigint — Primary key — NOT NULL
  • collection_id — bigint — NOT NULL
  • created_at — timestamptz — NOT NULL
  • hash_code — text — NOT NULL

Noti

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • event_id — bigint — NOT NULL
  • target_sync — timestamptz — 분석 완료 알림용
  • issued_at — timestamptz — NOT NULL
  • type — text — NOT NULL — type: "EVENT_NOTI", "ANALYSIS_NOTI"
  • title — text — NOT NULL
  • content — text — NOT NULL

Noti (Untitled14)

  • noti_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • noti_issued_date (Field2)
  • noti_type (Field4)
  • noti_title (Field)
  • noti_content (Field3)

OAuth2Account

  • id — bigint — Primary key — NOT NULL — 가입에 필요한 정보와 회원 정보를 분리했습니다
  • user_id — bigint — NOT NULL
  • email — text — NOT NULL
  • token_expires_at — timestamptz — NOT NULL
  • created_at — timestamptz — NOT NULL
  • subject — text — NOT NULL — 구글에서 제공하는 sub

OAuthAccount (Untitled17)

  • user_id (Key) — Foreign key → User.user_id — NOT NULL

Place (Untitled2)

  • place_id (Key3) — Foreign key → VisitTarget.target_id — NOT NULL
  • image_id (Key2) — Foreign key → Image.image_id — NOT NULL
  • place_type (Field)
  • google_place_id (Field2)

Place

  • id — bigint — Foreign key → Content.id — NOT NULL
  • image_id — bigint
  • type — text — NOT NULL
  • google_place_id — bigint — NOT NULL

SavedContent (Untitled4)

  • collection_id (Key) — Foreign key → Collection.collection_id — NOT NULL
  • content_id (Key2) — Foreign key → Content.content_id — NOT NULL
  • saved_at (Field)

SavedContent

  • collection_id — bigint — NOT NULL
  • content_id — bigint — NOT NULL
  • saved_at — timestamptz — NOT NULL

User

  • id — bigint — Primary key — NOT NULL
  • image_id — bigint
  • nickname — varchar(10) — NOT NULL
  • event_noti_agreed — boolean — NOT NULL
  • analysis_noti_agreed — boolean — NOT NULL
  • last_sync_completion_date — timestamptz
  • last_sync_requested_date — timestamptz
  • context — text — LLM 요청 시 함께 전달할 유저의 성향에 대한 컨텍스트가 압축된 문장

User (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • image_id (Key2) — Foreign key → Image.image_id — NOT NULL
  • nickname (Field)
  • event_noti_agreed (Field2)
  • analysis_noti_agreed (Field3)
  • last_sync_completion_date (Field4)
  • last_sync_requested_date (Field5)

Video

  • id — bigint — Primary key — NOT NULL
  • analysis_state — text — NOT NULL
  • video_link — text — NOT NULL

Video (Untitled12)

  • video_id (Key) — Primary key — NOT NULL
  • analysis_state (Field)
  • video_link (Field2)

VideoAnalysis (Untitled11)

  • analysis_id (Key3) — Primary key — NOT NULL
  • video_id (Key) — Foreign key → Video.video_id — NOT NULL
  • target_id (Key32) — Foreign key → VisitTarget.target_id — NOT NULL

VideoAnalysis

  • id — bigint — Primary key — NOT NULL
  • video_id — bigint — NOT NULL
  • content_id — bigint — NOT NULL
  • content_type — text — NOT NULL

VisitTarget (Untitled13)

  • target_id (Key3) — Foreign key → Content.content_id — NOT NULL