{"people": {"columns": [[0, "People_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Country", "TEXT", 0, null, 0], [3, "Is_Male", "TEXT", 0, null, 0], [4, "Age", "INT", 0, null, 0]], "primary_keys": ["People_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "People_ID"]]], "check_constraints": []}, "church": {"columns": [[0, "Church_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Organized_by", "TEXT", 0, null, 0], [3, "Open_Date", "INT", 0, null, 0], [4, "Continuation_of", "TEXT", 0, null, 0]], "primary_keys": ["Church_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Church_ID"]]], "check_constraints": []}, "wedding": {"columns": [[0, "Church_ID", "INT", 0, null, 1], [1, "Male_ID", "INT", 0, null, 2], [2, "Female_ID", "INT", 0, null, 3], [3, "Year", "INT", 0, null, 0]], "primary_keys": ["Church_ID", "Male_ID", "Female_ID"], "foreign_keys": [[0, 0, "people", "Female_ID", "People_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "people", "Male_ID", "People_ID", "NO ACTION", "NO ACTION", "NONE"], [2, 0, "church", "Church_ID", "Church_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Church_ID"], [1, 1, "Male_ID"], [2, 2, "Female_ID"]]], "check_constraints": []}}
CREATE TABLE people (
    People_ID INT   PRIMARY KEY,
    Name TEXT,
    Country TEXT,
    Is_Male TEXT,
    Age INT,
    UNIQUE (People_ID)
);

CREATE TABLE church (
    Church_ID INT   PRIMARY KEY,
    Name TEXT,
    Organized_by TEXT,
    Open_Date INT,
    Continuation_of TEXT,
    UNIQUE (Church_ID)
);

CREATE TABLE wedding (
    Church_ID INT   PRIMARY KEY,
    Male_ID INT   PRIMARY KEY,
    Female_ID INT   PRIMARY KEY,
    Year INT,
    PRIMARY KEY (Church_ID, Male_ID, Female_ID),
    UNIQUE (Church_ID, Male_ID, Female_ID),
    FOREIGN KEY (Female_ID) REFERENCES people(People_ID),
    FOREIGN KEY (Male_ID) REFERENCES people(People_ID),
    FOREIGN KEY (Church_ID) REFERENCES church(Church_ID)
);