simbaada
Tables (6)
daily_retrospects
- id — BIGINT — NOT NULL
- story_id — BIGINT — NOT NULL
- entry_date — DATE — NOT NULL
- title — VARCHAR(255)
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
letters
- id — BIGINT — NOT NULL
- story_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('EDITABLE','FINAL') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- image_cid — VARCHAR(255) — NOT NULL
- voice_cid — VARCHAR(255) — NOT NULL
- letter_cid — VARCHAR(255) — NOT NULL
- receiver — VARCHAR(255)
- reservation_date — DATETIME
- key_ref — VARCHAR(255) — NOT NULL
receivers
- id — BIGINT — NOT NULL
- sender_id — BIGINT — NOT NULL
- receiver_id — BIGINT — NOT NULL
- letter_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- wallet_address — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
records
- id — BIGINT — NOT NULL
- story_id — BIGINT — NOT NULL
- transcript_text — TEXT — NOT NULL
- summary_text — TEXT
- created_at — DATETIME — NOT NULL
stories
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- theme — VARCHAR(255) — NOT NULL
- color — VARCHAR(7) — NOT NULL
- started_at — DATETIME
- ended_at — DATETIME
- created_at — DATETIME — NOT NULL
- status — ENUM("IN_PROGRESS", "ENDED")
users
- id — BIGINT — Primary key — NOT NULL
- firebase_uid — VARCHAR(128) — NOT NULL
- google_id — VARCHAR(128)
- name — VARCHAR(100)
- nickname — VARCHAR(100)
- birthdate — DATE
- email — VARCHAR(100)
- wallet_address — VARCHAR(255) — NOT NULL
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- ai_voice — BOOLEAN