CREATE TABLE CST (
    cst_id int    NOT NULL ,
    rollno int    NOT NULL ,
    semester int    NOT NULL ,
    CONSTRAINT CST_pk PRIMARY KEY (cst_id)
);

CREATE TABLE UDT (
    udt_id int    NOT NULL ,
    id int    NOT NULL ,
    name varchar(255)    NOT NULL ,
    gender varchar(255)    NOT NULL ,
    fatherame varchar(255)    NOT NULL ,
    mothername varchar(255)    NOT NULL ,
    dob date    NOT NULL ,
    signature binary(255)    NOT NULL ,
    CONSTRAINT UDT_pk PRIMARY KEY (udt_id)
);

CREATE TABLE address (
    address_id int    NOT NULL ,
    id int    NOT NULL ,
    add_name varchar(255)    NOT NULL ,
    add_street varchar(255)    NOT NULL ,
    city varchar(255)    NOT NULL ,
    state varchar(255)    NOT NULL ,
    country varchar(255)    NOT NULL ,
    pin int    NOT NULL ,
    CONSTRAINT address_pk PRIMARY KEY (address_id)
);

CREATE TABLE courses (
    course_id int    NOT NULL ,
    course_name varchar(255)    NOT NULL ,
    CONSTRAINT courses_pk PRIMARY KEY (course_id)
);

CREATE TABLE phones (
    phone_id int    NOT NULL ,
    id int    NOT NULL ,
    phone int    NOT NULL ,
    CONSTRAINT phones_pk PRIMARY KEY (phone_id)
);

CREATE TABLE photos (
    photo_id int    NOT NULL ,
    id int    NOT NULL ,
    photo binary(255)    NOT NULL ,
    CONSTRAINT photos_pk PRIMARY KEY (photo_id)
);

CREATE TABLE sub_trans (
    sub_trans_id int    NOT NULL ,
    transactions_t_id int    NOT NULL ,
    subjects_sub_id int    NOT NULL ,
    CONSTRAINT sub_trans_pk PRIMARY KEY (sub_trans_id)
);

CREATE TABLE subjects (
    sub_id int    NOT NULL ,
    course_id int    NOT NULL ,
    subjectname varchar(255)    NOT NULL ,
    CONSTRAINT subjects_pk PRIMARY KEY (sub_id)
);

CREATE TABLE transactions (
    t_id int    NOT NULL ,
    id int    NOT NULL ,
    course_id int    NOT NULL ,
    p_status int    NOT NULL DEFAULT 0 ,
    phones_phone_id int    NOT NULL ,
    UDT_udt_id int    NOT NULL ,
    photos_photo_id int    NOT NULL ,
    address_address_id int    NOT NULL ,
    CST_cst_id int    NOT NULL ,
    CONSTRAINT transactions_pk PRIMARY KEY (t_id)
);

CREATE TABLE users (
    id int    NOT NULL ,
    name varchar(255)    NOT NULL ,
    email varchar(255)    NOT NULL ,
    password int    NOT NULL ,
    CONSTRAINT users_pk PRIMARY KEY (id)
);