alien

Tables (3)

Cake

  • cake_id (Key) — BIGINT(20) — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • type (Field2) — VARCHAR(255)

Candle

  • candle_id (Key) — BIGINT(20) — Primary key — NOT NULL
  • title (Field) — VARCHAR(255)
  • date (Field2) — DATETIME(6)
  • feeling (Field3) — SMALLINT(6)
  • body (Field4) — VARCHAR(255)

CandleCake

  • id (Key) — BIGINT(20) — Primary key — NOT NULL
  • candle_id (Key2) — BIGINT(20) — Foreign key → Candle.candle_id — NOT NULL
  • cake_id (Key3) — BIGINT(20) — Foreign key → Cake.cake_id — NOT NULL