PRAGMA foreign_keys = ON;

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'
);

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);