Dentis DB
Tables (11)
Copy Of dentis_db_xray (dentis_db_ceph)
- id — bigint — Primary key — NOT NULL
- treatment_id — bigint — Foreign key → dentis_db_treatment.id — NOT NULL
- ceph_img — varchar(100)
Copy Of dentis_db_xray2 (dentis_db_pano)
- id — bigint — Primary key — NOT NULL
- treatment_id — bigint — Foreign key → dentis_db_treatment.id — NOT NULL
- pano_img — varchar(100)
dentis_db_angle
- id — bigint — Primary key — NOT NULL
- treatment_id — bigint — Foreign key → dentis_db_treatment.id — NOT NULL
- left_class — integer — NOT NULL
- left_distance — real — NOT NULL
- right_class — integer — NOT NULL
- right_distance — real — NOT NULL
dentis_db_face
- id — bigint — Primary key — NOT NULL
- treatment_id — bigint — Foreign key → dentis_db_treatment.id — NOT NULL
- front_img — varchar(100)
- lateral_img — varchar(100)
- midline_img — varchar(100)
- smile_img — varchar(100)
dentis_db_intraoral
- id — bigint — Primary key — NOT NULL
- treatment_id — bigint — Foreign key → dentis_db_treatment.id — NOT NULL
- front_img — varchar(100)
- right_img — varchar(100)
- left_img — varchar(100)
- upper_img — varchar(100)
- lower_img — varchar(100)
dentis_db_organization
- id — integer — Primary key — NOT NULL
- code — varchar(2) — NOT NULL
- name — varchar(10) — NOT NULL
- area_number — varchar(3)
dentis_db_patient
- id — integer — Primary key — NOT NULL
- organization_id — integer — Foreign key → dentis_db_organization.id — NOT NULL
- id_str — varchar(10) — NOT NULL
- code — varchar(6) — NOT NULL
- sex — integer — NOT NULL
dentis_db_stl3d
- id — bigint — Primary key — NOT NULL
- treatment_id — bigint — Foreign key → dentis_db_treatment.id — NOT NULL
- lower — varchar(100)
- occlusal — varchar(100)
- upper — varchar(100)
dentis_db_treatment
- id — integer — Primary key — NOT NULL
- patient_id — bigint — Foreign key → dentis_db_patient.id — NOT NULL
- id_str — text — NOT NULL
- code — varchar(2) — NOT NULL
- patient_age — real — NOT NULL
- type — integer — NOT NULL
- phase — varchar(1) — NOT NULL
- lower_extraction — integer — NOT NULL
- upper_extraction — integer — NOT NULL
- lower_surgery — integer — NOT NULL
- upper_surgery — integer — NOT NULL
dentis_db_treatmentperiod
- id — bigint — Primary key — NOT NULL
- treatment_id — bigint — Foreign key → dentis_db_treatment.id — NOT NULL
- upper — real — NOT NULL
- lower — real — NOT NULL
dentis_db_xray
- id — bigint — Primary key — NOT NULL
- treatment_id — bigint — Foreign key → dentis_db_treatment.id — NOT NULL
- ceph_img — varchar(100)
- pano_img — varchar(100)