gikimi
Tables (9)
Academy
- academy_id — bigint — Foreign key → User.user_id — NOT NULL
Driver
- driver_id — bigint — Foreign key → User.user_id — NOT NULL
DriverAcademy
- driver_academy_id — bigint — Primary key — NOT NULL
- driver_id — bigint — Foreign key → Driver.driver_id — NOT NULL
- academy_id — bigint — Foreign key → Academy.academy_id — NOT NULL
Notification
- notification id (notification_id) — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- title — varchar(100) — NOT NULL
- content — varchar(255) — NOT NULL
- is read (is_read) — boolean — NOT NULL
- sent datetime (sent_at) — datetime — NOT NULL
- read datetime (read_at) — datetime — NOT NULL
Parent
- parent_id — bigint — Foreign key → User.user_id — NOT NULL
ParentAcademy
- parent_academy_id — bigint — Primary key — NOT NULL
- parent_id — bigint — Foreign key → Parent.parent_id — NOT NULL
- academy_id — bigint — Foreign key → Academy.academy_id — NOT NULL
Student
- student_id — bigint — Foreign key → User.user_id — NOT NULL
- parent_id — bigint — Foreign key → Parent.parent_id — NOT NULL
StudentAcademy
- student_academy_id — bigint — Primary key — NOT NULL
- student_id — bigint — Foreign key → Student.student_id — NOT NULL
- academy_id — bigint — Foreign key → Academy.academy_id — NOT NULL
User
- user_id — bigint — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(50) — NOT NULL
- email — varchar(50) — NOT NULL
- fcm token (fcm_token) — varchar(100) — NOT NULL — token 관리 redis 고려
- refresh token — varchar(100) — NOT NULL — token 관리 redis 고려