Victor Lacasse-Beaudoin
e847f693e0
- ajouter et tester InsertMembres - ajouter sql/views.sql - ajouter view `membres_for_display` -> concat names ou prefered name - rendre plusieurs champs NOT NULL dans schema
12 lines
303 B
SQL
12 lines
303 B
SQL
CREATE TABLE IF NOT EXISTS programmes (
|
|
id TEXT PRIMARY KEY,
|
|
name TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS membres (
|
|
id VARCHAR(7) PRIMARY KEY,
|
|
last_name TEXT NOT NULL,
|
|
first_name TEXT NOT NULL,
|
|
prefered_name TEXT,
|
|
programme_id TEXT REFERENCES programmes(id) NOT NULL
|
|
);
|