15 lines
267 B
SQL
15 lines
267 B
SQL
|
|
CREATE TABLE patients (
|
|
id SERIAL PRIMARY KEY,
|
|
name TEXT,
|
|
gender TEXT,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
CREATE TABLE visits (
|
|
id SERIAL PRIMARY KEY,
|
|
patient_id INT,
|
|
visit_type TEXT,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|