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)