PRAGMA foreign_keys = ON; /*allows the use of foreign keys*/

-- creates a table for STUDENT
CREATE TABLE STUDENT (
Student_ID INTEGER PRIMARY KEY,
Student_Name TEXT NOT NULL,
Email TEXT NOT NULL UNIQUE,

Program TEXT NOT NULL,
Year_Level INTEGER CHECK (Year_Level BETWEEN 1 AND 5),
Status TEXT NOT NULL DEFAULT 'Active'
);

PRAGMA table_info(STUDENT);

-- creates a table for CLUB
CREATE TABLE CLUB (
Club_ID INTEGER PRIMARY KEY,
Club_Name TEXT NOT NULL UNIQUE,
Category TEXT NOT NULL,
Maximum_Members INTEGER NOT NULL CHECK (Maximum_Members > 0),
Club_Status TEXT NOT NULL DEFAULT 'Open'
);
PRAGMA table_info(CLUB);