Primeiramente vamos criar o banco de dados clínica através do comando
CREATE DATABASE clinica DEFAULT COLLATE utf8_general_ci;
Em seguida criamos as tabelas de médico, paciente e consulta.
CREATE TABLE medico (
id INT AUTO_INCREMENT PRIMARY KEY,
| # Editor configuration, see http://editorconfig.org | |
| root = true | |
| [*] | |
| charset = utf-8 | |
| indent_style = space | |
| indent_size = 2 | |
| insert_final_newline = true | |
| trim_trailing_whitespace = true |
| export default { | |
| border: { | |
| radius: '0.5rem' | |
| }, | |
| font: { | |
| family: "'Open Sans', sans-serif", | |
| normal: 400, | |
| bold: 600, | |
| xbold: 700, | |
| sizes: { |
| export function valueToColorScale( | |
| value: number, | |
| minColor: string, | |
| maxColor: string, | |
| minValue: number, | |
| maxValue: number | |
| ) { | |
| const [ | |
| redMinColorInHex, | |
| greenMinColorInHex, |
| [ | |
| ["City", "Population"], | |
| ["Sao Paulo", 12325232], | |
| ["Rio de Janeiro", 6747815], | |
| ["Brasilia", 3055149], | |
| ["Salvador", 2886698], | |
| ["Fortaleza", 2686612], | |
| ["Belo Horizonte", 2521564], | |
| ["Manaus", 2219580], | |
| ["Curitiba", 1948626], |
| [ | |
| ["City", "Population"], | |
| ["São Paulo", 46289333], | |
| ["Rio de Janeiro", 6747815], | |
| ["Distrito Federal", 3055149], | |
| ["Bahia", 14930634], | |
| ["Ceará", 9187103], | |
| ["Minas Gerais", 21292666], | |
| ["Amazonas", 4207714], | |
| ["Paraná", 11516840], |
| {"version":1,"resource":"file:///Users/tonhao/Documents/usabit/usabit%20space/usabit-space-app/src/services/SpaceData/index.ts","entries":[{"id":"CAu5.ts","source":"Renaming updateContent to updateIdentity","timestamp":1662674160846},{"id":"zbIt.ts","timestamp":1662674360889},{"id":"xsj8.ts","source":"Add import from \"@/utils/getFormData\"","timestamp":1662674380578},{"id":"3ink.ts","timestamp":1666288402455},{"id":"fm9l.ts","timestamp":1666288665584},{"id":"Eip4.ts","timestamp":1666289346916}]} |