Column Name

Primary key

Data type

NOT NULL

AUTO INC

ID

Username

Password

First name

Middle name

Last name

Title

Department

Address

Sex

Yes

INTEGER

VARCHAR (45)

VARCHAR (45)

VARCHAR 45)

VARCHAR (45)

VARCHAR (45)

VARCHAR (45)

VARCHAR (45)

VARCHAR (4500)

VARCHAR (45)

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Yes