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