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