cheesemoa

Tables (10)

BaseEntity

  • createdAt — DATETIME
  • updatedAt — DATETIME

album

  • album_id — BIGINT — Primary key — NOT NULL
  • moment_id — BIGINT — Foreign key → moment.moment_id — NOT NULL
  • space_person_id — BIGINT — Foreign key → space_person.space_person_id — NOT NULL
  • thumbnail_photo_id — BIGINT
  • type — VARCHAR(20)

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
  • review_status — VARCHAR(20)

moment

  • moment_id — BIGINT — Primary key — NOT NULL
  • space_id — BIGINT — Foreign key → space.space_id — NOT NULL
  • title — VARCHAR(255)
  • thumbnail_photo_id — BIGINT
  • status — VARCHAR(20)
  • event_date — DATE
  • created_by — BIGINT
  • published_at — DATETIME

person

  • person_id — BIGINT — Primary key — NOT NULL
  • vector — VECTOR(512)

photo

  • photo_id — BIGINT — Primary key — NOT NULL
  • s3_key — VARCHAR(500) — NOT NULL
  • latitude — VARCHAR(255)
  • longitude — VARCHAR(255)
  • blurry — BOOLEAN
  • eyes_closed — BOOLEAN

space

  • space_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • join_key — VARCHAR(20)
  • share_token — VARCHAR(20)
  • share_password — VARCHAR(6)
  • join_password — VARCHAR(6)

space_person

  • space_person_id — BIGINT — Primary key — NOT NULL
  • space_id — BIGINT — Foreign key → space.space_id — NOT NULL
  • person_id — BIGINT — Foreign key → person.person_id — NOT NULL
  • name — VARCHAR(20)

space_user

  • space_user_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • space_id — BIGINT — Foreign key → space.space_id — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(100)
  • password — VARCHAR(100)