-- Create 
CREATE TABLE `` ();
-- Create Guests
CREATE TABLE `Guests` ( `Email` VARCHAR(60) NULL,  `First_Name` VARCHAR(60) NULL,  `Guest_ID` INT NOT NULL,  `Last_Name` VARCHAR(60) NULL,  `Password` VARCHAR(20) NULL,  `Security_Level` INT NOT NULL,  `Username` VARCHAR(20) NOT NULL ,PRIMARY KEY (`Guest_ID`), UNIQUE KEY `Index_79A48581_B529_423F` (`Guest_ID`));
-- Create Registry Items
CREATE TABLE `Registry Items` ( `Brand` VARCHAR(255) NULL,  `Cost` FLOAT NULL,  `Description` VARCHAR(255) NULL,  `Item_ID` INT NOT NULL,  `Model` VARCHAR(255) NULL,  `Other_Info` TEXT NULL,  `Picture` VARCHAR(255) NULL,  `Qty` INT NULL,  `QTY_Left` INT NULL,  `Source` VARCHAR(255) NULL,  `Web_Site` VARCHAR(255) NULL ,PRIMARY KEY (`Item_ID`), UNIQUE KEY `Index_3111CF1A_1126_4B56` (`Item_ID`));
-- Create Selection
CREATE TABLE `Selection` ( `BRAND` VARCHAR(50) NULL,  `COST` VARCHAR(50) NULL,  `DESCRIPTION` VARCHAR(50) NULL,  `FIRST` VARCHAR(50) NULL,  `LAST` VARCHAR(50) NULL,  `MODEL` VARCHAR(50) NULL,  `OTHER_INFO` VARCHAR(255) NULL,  `PHRASE` VARCHAR(50) NULL,  `QTY` VARCHAR(255) NULL,  `RecordID` INT NULL,  `SHOP` VARCHAR(50) NULL ,PRIMARY KEY (`RecordID`));
-- Create Selections
CREATE TABLE `Selections` ( `Guest_First_Name` VARCHAR(60) NULL,  `Guest_ID` INT NULL,  `Guest_Last_Name` VARCHAR(60) NULL,  `Guest_Username` VARCHAR(20) NULL,  `Item_Description` VARCHAR(255) NULL,  `Item_ID` INT NULL,  `Quantity` INT NULL,  `Selection_ID` INT NOT NULL ,PRIMARY KEY (`Selection_ID`), UNIQUE KEY `Index_AD775812_0D12_409C` (`Selection_ID`));
