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
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