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