nadle

Tables (7)

Budget

  • id — BIGINT — Primary key
  • planner_id — BIGINT — Foreign key → Schedule.planner_id
  • description — TEXT — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL

Notification

  • Field — Primary key

Place

  • id — BIGINT — Primary key
  • google_id — VARCHAR(255)
  • name — DATETIME — NOT NULL

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)

Schedule

  • id — BIGINT — Primary key
  • planner_id — BIGINT — Foreign key → Planner.id
  • place_id — BIGINT — Foreign key → Place.id
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • element_type — VARCHAR(50) — NOT NULL

User

  • id — Primary key — NOT NULL
  • email — NOT NULL
  • password
  • ROLE

UserPlannerJoin

  • id — Primary key
  • user_id — Foreign key → User.id — NOT NULL
  • planner_id — BIGINT — Foreign key → Planner.id
  • ROLE — NOT NULL