CREATE TABLE bool
(
    "name" TEXT default '' not null
        primary key
);
bool
CREATE TABLE person
(
    "name" TEXT default '' not null
        primary key
);
person
CREATE TABLE disabled
(
    "name" TEXT default '' not null
        primary key,
        foreign key ("name") references person ("name")
            on update cascade on delete cascade
);
disabled
CREATE TABLE enlist
(
    "name"  TEXT not null,
    organ TEXT not null,
        foreign key ("name") references person ("name")
            on update cascade on delete cascade
);
enlist
CREATE TABLE filed_for_bankrupcy
(
    "name" TEXT default '' not null
        primary key,
        foreign key ("name") references person ("name")
            on update cascade on delete cascade
);
filed_for_bankrupcy
CREATE TABLE longest_absense_from_school
(
    "name"  TEXT default '' not null
        primary key,
    "month" INTEGER       default 0  null,
        foreign key ("name") references person ("name")
            on update cascade on delete cascade
);
longest_absense_from_school
CREATE TABLE male
(
    "name" TEXT default '' not null
        primary key,
        foreign key ("name") references person ("name")
            on update cascade on delete cascade
);
male
CREATE TABLE no_payment_due
(
    "name" TEXT default '' not null
        primary key,
    bool TEXT             null,
        foreign key ("name") references person ("name")
            on update cascade on delete cascade,
        foreign key (bool) references bool ("name")
            on update cascade on delete cascade
);
no_payment_due
CREATE TABLE unemployed
(
    "name" TEXT default '' not null
        primary key,
        foreign key ("name") references person ("name")
            on update cascade on delete cascade
);
unemployed
CREATE TABLE `enrolled` (
  `name` TEXT NOT NULL,
  `school` TEXT NOT NULL,
  `month` INTEGER NOT NULL DEFAULT 0,
  PRIMARY KEY (`name`,`school`),
  FOREIGN KEY (`name`) REFERENCES `person` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
);
enrolled
original_column_name,column_name,column_description,data_format,value_description
name,,the name of the disabled students,text,
disabled
original_column_name,column_name,column_description,data_format,value_description
name,,student name who filed for bankruptcy,text,
filed_for_bankruptcy
original_column_name,column_name,column_description,data_format,value_description
name,,,text,
bool
original_column_name,column_name,column_description,data_format,value_description
name,,the name of the enlisted students,text,
organ,organization,the organization that the student enlisted in ,text,
enlist
original_column_name,column_name,column_description,data_format,value_description
name,,student's name ,text,
bool,,whether the student has payment dues,text,"commonsense evidence:
	neg: the student doesn't have payment due
	pos: the student has payment due"
no_payment_due
original_column_name,column_name,column_description,data_format,value_description
name,,student's name,text,
month,,the duration of absence,integer,"commonsense evidence:
0 means that the student has never been absent. "
longest_absense_from_school
original_column_name,column_name,column_description,data_format,value_description
name,,,text,
school,,,text,
month,,,integer,
enrolled
original_column_name,column_name,column_description,data_format,value_description
name,,student's name who are male,text,"commonsense evidence:
the students who are not in this list are female."
male
original_column_name,column_name,column_description,data_format,value_description
name,,student's name,text,
person
original_column_name,column_name,column_description,data_format,value_description
name,,student who is unemployed,text,
unemployed