TimeCapsule
Tables (5)
Capsule
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- status — VARCHAR(50) — NOT NULL
- open_time — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
CapsuleS3
- id — BIGINT
- capsule_id — BIGINT — NOT NULL
- s3_url — VARCHAR(500) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
User
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
UserCapsule
- user_id — BIGINT — Primary key — NOT NULL
- capsule_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
UserImage
- id — BIGINT
- user_id — BIGINT — NOT NULL
- s3_url — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL