lettersoup-online/001_documentation/Requirements/REQ0006/schema.dbml

// Generated at:  2025-05-11T08:58:29.867Z


// 
// collection id:   pbc_3142635823 
// collection name: _superusers 
// collection type: auth 
Table _superusers {
  id text [pk, not null]
  password varchar [not null]
  tokenKey text [not null]
  email text [not null]
  emailVisibility boolean
  verified boolean
  created datetime
  updated datetime
}

// 
// collection id:   _pb_users_auth_ 
// collection name: users 
// collection type: auth 
Table users {
  id text [pk, not null]
  password varchar [not null]
  tokenKey text [not null]
  email text [not null]
  emailVisibility boolean
  verified boolean
  name text
  avatar file
  created datetime
  updated datetime
  visible text
  phone text
}

// 
// collection id:   pbc_1430376151 
// collection name: Categories 
// collection type: base 
Table Categories {
  id text [pk, not null]
  cat_name text
  cat_image_url text
  cat_image file
  pos integer
  lesson_id integer [ref: > LessonsTypes.id] // relation3455582614
  remarks text
  visible text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_108570809 
// collection name: Customers 
// collection type: base 
Table Customers {
  id text [pk, not null]
  name text
  email text
  phone text
  quota integer
  status text
  avatar_file file
  user_id integer [ref: > users.id] // relation2809058197
  billingAddress text
  timezone text
  language text
  currency text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_1196309394 
// collection name: LessonsCategories 
// collection type: base 
Table LessonsCategories {
  id text [pk, not null]
  cat_name text
  cat_image_url text
  cat_image file
  pos integer
  lesson_id integer [ref: > LessonsTypes.id] // relation3455582614
  description text
  remarks text
  visible text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_2328411368 
// collection name: LessonsTypes 
// collection type: base 
Table LessonsTypes {
  id text [pk, not null]
  name text
  type text
  pos integer
  visible text
  created datetime
  updated datetime
  field datetime
}

// 
// collection id:   pbc_977978967 
// collection name: Notifications 
// collection type: base 
Table Notifications {
  id text [pk, not null]
  read boolean
  type text
  author text
  job text
  description text
  NOTI_ID text
  created datetime
  updated datetime
  to_user_id integer [ref: > UserMetas.id] // relation704048736
  from_user_id integer [ref: > UserMetas.id] // relation556806202
}

// 
// collection id:   pbc_4061499106 
// collection name: QuizCRCategories 
// collection type: base 
Table QuizCRCategories {
  id text [pk, not null]
  cat_name text
  cat_image file
  pos integer
  init_answer text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_3141885671 
// collection name: QuizCRQuestions 
// collection type: base 
Table QuizCRQuestions {
  id text [pk, not null]
  question_fh text
  question_sh text
  modal_ans text
  cat_id integer [ref: > QuizCRCategories.id] // relation1827623476
  options text
  created datetime
  updated datetime
  init_answer text
}

// 
// collection id:   pbc_3571292172 
// collection name: QuizCategories 
// collection type: base 
Table QuizCategories {
  id text [pk, not null]
  cat_name text
  cat_image text
  init_answer text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_96745150 
// collection name: QuizConnectives 
// collection type: base 
Table QuizConnectives {
  id text [pk, not null]
  question_fh text
  question_sh text
  modal_ans text
  cat_id integer [ref: > QuizConnectivesCategories.id] // relation3870140739
  created datetime
  updated datetime
}

// 
// collection id:   pbc_342761728 
// collection name: QuizConnectivesCategories 
// collection type: base 
Table QuizConnectivesCategories {
  id text [pk, not null]
  cat_name text
  cat_image file
  created datetime
  updated datetime
}

// 
// collection id:   pbc_3639453778 
// collection name: QuizLPCategories 
// collection type: base 
Table QuizLPCategories {
  id text [pk, not null]
  cat_name text
  cat_image file
  pos integer
  init_answer text
  created datetime
  updated datetime
  visible text
  slug text
  remarks text
  description text
}

// 
// collection id:   pbc_742947356 
// collection name: QuizLPQuestions 
// collection type: base 
Table QuizLPQuestions {
  id text [pk, not null]
  word text
  sound file
  cat_id integer [ref: > QuizLPCategories.id] // relation3870140739
  created datetime
  updated datetime
  cat_name text
  cat_image file
  pos integer
  init_answer text
  visible text
  slug text
  remarks text
  description text
}

// 
// collection id:   pbc_2511066072 
// collection name: QuizListenings 
// collection type: base 
Table QuizListenings {
  id text [pk, not null]
  sound file
  word text
  cat_id integer [ref: > QuizCategories.id] // relation3870140739
  created datetime
  updated datetime
}

// 
// collection id:   pbc_84667061 
// collection name: QuizMFCategories 
// collection type: base 
Table QuizMFCategories {
  id text [pk, not null]
  cat_name text
  cat_image file
  pos integer
  init_answer text
  created datetime
  updated datetime
  visible text
}

// 
// collection id:   pbc_3346420851 
// collection name: QuizMFQuestions 
// collection type: base 
Table QuizMFQuestions {
  id text [pk, not null]
  word text
  word_c text
  cat_id integer [ref: > QuizMFCategories.id] // relation3870140739
  created datetime
  updated datetime
  visible text
  sound file
  cat_image file
  init_answer text
}

// 
// collection id:   pbc_2936646783 
// collection name: QuizMatchings 
// collection type: base 
Table QuizMatchings {
  id text [pk, not null]
  word text
  word_c text
  cat_id integer [ref: > QuizCategories.id] // relation3870140739
  created datetime
  updated datetime
}

// 
// collection id:   pbc_491894781 
// collection name: Students 
// collection type: base 
Table Students {
  id text [pk, not null]
  name text
  email text
  phone text
  quota integer
  status text
  avatar_file file
  user_id integer [ref: > users.id] // relation2809058197
  billingAddress text
  timezone text
  language text
  currency text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_1413424569 
// collection name: Teachers 
// collection type: base 
Table Teachers {
  id text [pk, not null]
  name text
  email text
  phone text
  quota integer
  status text
  avatar_file file
  user_id integer [ref: > users.id] // relation2809058197
  billingAddress text
  timezone text
  language text
  currency text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_1305841361 
// collection name: UserMetas 
// collection type: base 
Table UserMetas {
  id text [pk, not null]
  helloworld text
  meta text
  user_id integer [ref: > users.id] // relation2809058197
  created datetime
  updated datetime
  status text
  avatar file
  role text
  name text
  email text
  phone text
}

// 
// collection id:   pbc_1638686383 
// collection name: Vocabularies 
// collection type: base 
Table Vocabularies {
  id text [pk, not null]
  image file
  sound file
  word text
  word_c text
  sample_e text
  sample_c text
  cat_id integer [ref: > Categories.id] // relation3870140739
  category text
  lesson_type_id integer [ref: > LessonsTypes.id] // relation808508980
  created datetime
  updated datetime
  visible text
  type text
}

// 
// collection id:   pbc_4275539003 
// collection name: _authOrigins 
// collection type: base 
Table _authOrigins {
  id text [pk, not null]
  collectionRef text [not null]
  recordRef text [not null]
  fingerprint text [not null]
  created datetime
  updated datetime
}

// 
// collection id:   pbc_2281828961 
// collection name: _externalAuths 
// collection type: base 
Table _externalAuths {
  id text [pk, not null]
  collectionRef text [not null]
  recordRef text [not null]
  provider text [not null]
  providerId text [not null]
  created datetime
  updated datetime
}

// 
// collection id:   pbc_2279338944 
// collection name: _mfas 
// collection type: base 
Table _mfas {
  id text [pk, not null]
  collectionRef text [not null]
  recordRef text [not null]
  method text [not null]
  created datetime
  updated datetime
}

// 
// collection id:   pbc_1638494021 
// collection name: _otps 
// collection type: base 
Table _otps {
  id text [pk, not null]
  collectionRef text [not null]
  recordRef text [not null]
  password varchar [not null]
  sentTo text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_1509025625 
// collection name: billingAddress 
// collection type: base 
Table billingAddress {
  id text [pk, not null]
  country text
  state text
  city text
  zipCode text
  line1 text
  line2 text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_123408445 
// collection name: helloworlds 
// collection type: base 
Table helloworlds {
  id text [pk, not null]
  hello text
  created datetime
  updated datetime
}

// 
// collection id:   pbc_2109205374 
// collection name: t1 
// collection type: base 
Table t1 {
  id text [pk, not null]
  hello text
  created datetime
  updated datetime
  test_file file
}