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