DearKeki
Tables (5)
Cake
- id — BIGSERIAL — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → User.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- theme — VARCHAR(50)
- candle_count — INT — NOT NULL
- share_code — VARCHAR(50) — NOT NULL
- expired_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
Candle
- id — BIGSERIAL — Primary key — NOT NULL
- cake_id — BIGINT — Foreign key → Cake.id — NOT NULL
- user_id — BIGINT — Foreign key → User.id
- nick — VARCHAR(50)
- message — TEXT — NOT NULL
- color — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
Contact
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- answer — TEXT
- answered_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
FAQ
- id — BIGSERIAL — Primary key — NOT NULL
- question — TEXT — NOT NULL
- answer — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
User
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nick — VARCHAR(50) — NOT NULL
- profile_img — TEXT
- allow_guest — BOOLEAN — NOT NULL
- provider — VARCHAR(20)
- provider_id — VARCHAR(255)
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- terms_agreed_at — TIMESTAMP