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