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)