SELECT * FROM `x$schema_flattened_keys`
|
table_schema | table_name | index_name | non_unique | subpart_exists | index_columns | |
---|---|---|---|---|---|---|
ATDMV | ENGAÑO | PRIMARY | 0 | 0 | IDENGAÑO | |
HospitalDB | consists_of | PRIMARY | 0 | 0 | staff_no | |
HospitalDB | consists_of | team_in_consists_of | 1 | 0 | team_code | |
HospitalDB | doctor | PRIMARY | 0 | 0 | staff_no | |
HospitalDB | drug | PRIMARY | 0 | 0 | drug_code | |
HospitalDB | nurse | nurse_in_staffed_by | 1 | 0 | ward_no | |
HospitalDB | nurse | PRIMARY | 0 | 0 | staff_no | |
HospitalDB | patient | patient_in_is_responsible_for | 1 | 0 | staff_no | |
HospitalDB | patient | patient_in_occupied_by | 1 | 0 | ward_no | |
HospitalDB | patient | PRIMARY | 0 | 0 | patient_id | |
HospitalDB | prescription | prescription_in_is_used | 1 | 0 | drug_code | |
HospitalDB | prescription | prescription_in_requires | 1 | 0 | staff_no,patient_id,start_date | |
HospitalDB | prescription | PRIMARY | 0 | 0 | prescription_no | |
HospitalDB | small_occupied_by | PRIMARY | 0 | 0 | patient_id | |
HospitalDB | small_ward | PRIMARY | 0 | 0 | ward_no | |
HospitalDB | specialist | PRIMARY | 0 | 0 | staff_no | |
HospitalDB | supervises | PRIMARY | 0 | 0 | staff_no | |
HospitalDB | supervises | supervisor_in_supervises | 1 | 0 | supervisor | |
HospitalDB | team | PRIMARY | 0 | 0 | team_code | |
HospitalDB | team | staff_no | 0 | 0 | staff_no | |
HospitalDB | treatment | PRIMARY | 0 | 0 | staff_no,patient_id,start_date | |
HospitalDB | treatment | treatment_in_receives | 1 | 0 | patient_id | |
HospitalDB | ward | PRIMARY | 0 | 0 | ward_no | |
StdMdDB | course | PRIMARY | 0 | 0 | id | |
StdMdDB | student | PRIMARY | 0 | 0 | id |
|