est

Tables (3)

Planner

  • id — BIGINT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • budget_total — DECIMAL(10,2)

User

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(61)
  • name — VARCHAR(20)
  • provider — VARCHAR(20)
  • image_url — TEXT
  • USER_ROLE — VARCHAR(255)

UserPlannerJoin

  • id — BIGINT — Foreign key → User.id — NOT NULL
  • user_id — BIGINT — Foreign key → Planner.id
  • planner_id — BIGINT — Foreign key → Planner.id
  • ROLE — VARCHAR(255) — NOT NULL