USE `contractordb` ;
#
#
CREATE TABLE contractordb.people (
STATUS VARCHAR(16) NOT NULL,
TYPE VARCHAR(32) NOT NULL,
CONTRACTOR_NUMBER VARCHAR(12),
NAME_FIRST VARCHAR(30) NOT NULL,
NAME_LAST VARCHAR(30) NOT NULL,
NAME_FULL VARCHAR(60),
NAME_FIRST_UTF8 VARCHAR(30),
NAME_LAST_UTF8 VARCHAR(30),
NAME_FULL_UTF8 VARCHAR(60),
SUNRISE_DATE DATE,
SUNSET_DATE DATE,
TITLE VARCHAR(48),
EMAIL VARCHAR(60),
PHONE_WORK VARCHAR(20),
ORGANIZATION VARCHAR(48),
LOCATION VARCHAR(20),
SPONSOR VARCHAR(12),
DATE_BIRTH VARCHAR(12),
SSN_LASTFOUR VARCHAR(4),
CHANGE_TIMESTEMP TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,