s
Tables (4)
comment
- id — int — Primary key — NOT NULL
- schedule_id — int — Foreign key → schedule.id — NOT NULL
- content — varchar(300) — NOT NULL
- username — varchar(100) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
manager
- id — int — Primary key — NOT NULL
- schedule_id — int — Foreign key → schedule.id — NOT NULL
- user_id — int — Foreign key → user.id — NOT NULL
schedule
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- title — varchar(200)
- content — varchar(500)
- created_at — datetime
- updated_at — timestamp
- weather — varchar(200)
user
- id — int — Primary key — NOT NULL
- username — varchar(100) — NOT NULL
- email — varchar(200) — NOT NULL
- password — varchar(150)
- role — varchar(100)
- created_at — timestamp
- updated_at — timestamp