cheesemoa-version1
Tables (14)
album
- album_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- review_status — varchar(20)
- thumbnail_photo_id — bigint
- type — varchar(20)
- moment_id — bigint — Foreign key → moment.moment_id — NOT NULL
- space_person_id — bigint — Foreign key → space_person.space_person_id
- face_thumbnail_key — varchar(500)
album_photo
- album_photo_id — bigint — Primary key — NOT NULL
- album_id — bigint — Foreign key → album.album_id — NOT NULL
- photo_id — bigint — Foreign key → photo.photo_id — NOT NULL
- reviewed — boolean — NOT NULL
moment
- moment_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- created_by — bigint
- event_date — date
- published_at — timestamp(6)
- status — varchar(20)
- thumbnail_photo_id — bigint
- title — varchar(255)
- space_id — bigint — Foreign key → space.space_id — NOT NULL
person
- person_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- vector — vector(512)
person_cluster
- person_cluster_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- cluster_id — varchar(64) — NOT NULL
- person_id — bigint — Foreign key → person.person_id — NOT NULL
photo
- photo_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- blurry — boolean
- eyes_closed — boolean
- latitude — varchar(255)
- longitude — varchar(255)
- s3_key — varchar(500) — NOT NULL
- reviewed — boolean
- content_hash — varchar(32)
- published — boolean — NOT NULL
- face_bboxes — jsonb
photo_upload
- photo_upload_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- exclude_blurry — boolean
- exclude_eyes_closed — boolean
- image_id — varchar(36) — NOT NULL
- job_id — varchar(36) — NOT NULL
- processed_at — timestamp(6)
- s3_key — varchar(500) — NOT NULL
- moment_id — bigint — Foreign key → moment.moment_id — NOT NULL
- content_hash — varchar(32)
refresh_token
- refresh_token_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- expires_at — timestamp(6) — NOT NULL
- token — varchar(64) — NOT NULL
- user_id — bigint — NOT NULL
social_account
- social_account_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- provider — varchar(20) — NOT NULL
- provider_user_id — varchar(64) — NOT NULL
- user_id — bigint — NOT NULL
social_auth_code
- social_auth_code_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6) — NOT NULL
- updated_at — timestamp(6) — NOT NULL
- code — varchar(64) — NOT NULL
- expires_at — timestamp(6) — NOT NULL
- user_id — bigint — NOT NULL
space
- space_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- join_key — varchar(20)
- join_password — varchar(100)
- share_password — varchar(100)
- share_token — varchar(20)
- title — varchar(255) — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
space_person
- space_person_id — bigint — Primary key — NOT NULL
- name — varchar(20)
- person_id — bigint — Foreign key → person.person_id — NOT NULL
- space_id — bigint — Foreign key → space.space_id — NOT NULL
space_user
- space_user_id — bigint — Primary key — NOT NULL
- space_id — bigint — Foreign key → space.space_id — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
user
- user_id — bigint — Primary key — NOT NULL
- created_at — timestamp(6)
- updated_at — timestamp(6)
- nickname — varchar(20)
- password — varchar(60)
- role — varchar(20) — NOT NULL