Mailedit

Tables (5)

BaseTemplate (Untitled5)

  • template_id (Key) — uuid — Primary key — NOT NULL
  • title (Field) — varchar
  • subtitle (Field2) — varchar
  • info_text (Field4) — varchar
  • content (Field3) — json

Block (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • index (Field3) — int
  • text (Field) — varchar
  • tag (Field4) — varchar
  • flag (Field2) — boolean
  • template_id (Key2) — uuid — Foreign key → Template.template_id — NOT NULL

Group (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • color (Field2) — hex
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL

Template (Untitled2)

  • template_id (Key) — uuid — Primary key — NOT NULL
  • title (Field) — varchar
  • subtitle (Field2) — varchar
  • content (Field7) — json
  • is_star (Field6) — boolean
  • created_at (Field8) — Timestamp
  • updated_at (Field3) — Timestamp
  • user_id (Key2) — int — Foreign key → User.id — NOT NULL
  • group_id (Key3) — int — Foreign key → Group.id — NOT NULL

User (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • username — varchar
  • email — varchar
  • password — varchar
  • login_type (type) — varchar
  • created_at (Field) — Timestamp
  • updated_at (Field2) — Timestamp