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