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