test

Tables (9)

children_counselor_relations

  • id — UUID
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL
  • relation_status — relation_status — NOT NULL

children_parent_relations

  • id — BIGINT
  • relation_status — relation_status — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL
  • children_id — UUID — Foreign key → childrens.id — NOT NULL
  • parent_id — UUID — Foreign key → parents.id — NOT NULL

childrens

  • id — UUID — Foreign key → users.id
  • birth — VARCHAR — NOT NULL
  • gender — gender — NOT NULL

counselors

  • id — UUID — Foreign key → users.id
  • hospital_name — VARCHAR — NOT NULL
  • hospital_address — VARCHAR — NOT NULL

devices

  • id — UUID
  • serial_number — VARCHAR — NOT NULL
  • paired_at — TIMESTAMP — NOT NULL
  • is_paired — BOOLEAN — NOT NULL
  • parent_id — UUID — Foreign key → parents.id — NOT NULL

parent_counselor_relations

  • id — BIGINT
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP — NOT NULL
  • relation_status — relation_status — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL
  • counselor_id — UUID — Foreign key → counselors.id — NOT NULL
  • parent_id — UUID — Foreign key → parents.id — NOT NULL

parents

  • id — UUID — Foreign key → users.id
  • code — VARCHAR — NOT NULL

social_users

  • id — UUID
  • provider — VARCHAR — NOT NULL
  • provider_user_id — VARCHAR — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL

users

  • id — UUID
  • email — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • name — VARCHAR — NOT NULL
  • phone — VARCHAR — NOT NULL
  • role — user_role — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL