 
 DROP TABLE IF EXISTS packages;
 CREATE TABLE packages (
-	-- 	id does not have attribute constraints.
-	-- See roles(id)
-	id             INT(10)      NOT NULL ,
+
+	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
 	user_id        INT(10)      NOT NULL ,
 	post_office    INT(10)      NOT NULL ,
 	type_id        INT ,
 	transaction_id INT ,
-	destination    VARCHAR(255) NOT NULL ,
-	-- May need city, state, zip
+	destination_address   VARCHAR(255) NOT NULL ,
+	destination_city            VARCHAR (50),
+	destination_state        VARCHAR (50),
+	destination_zipcode      INT(5),
 	return_address VARCHAR(255) NOT NULL ,
-	-- May need city, state, zip
-	-- Here I thought it might be a good idea to
-	-- make this into its own entity.
-	-- We can discuss tomorrow
+	return_city     VARCHAR(50),
+	return_state    VARCHAR (50),
+	return_zipcode          INT(5),
+
+);
+
+DROP TABLE IF EXISTS packageContents;
+CREATE TABLE packageContents (
+
 	contents       VARCHAR(255) ,
 	weight         DOUBLE ,
 	priority       BOOL ,


DROP TABLE IF EXISTS state;
CREATE TABLE state (
	-- 	id does not have attribute constraints.
	-- See roles(id)
	id         INT(10) ,
	state      VARCHAR(2) ,
	count      INT ,
	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP


DROP TABLE IF EXISTS transactions;
CREATE TABLE transactions (

	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
	user_id        INT(10) ,
	post_office_id INT(10) ,
	cost           DOUBLE ,
	employee_id    INT(10) ,
	package_id     INT(10) ,
	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
	updated_at TIMESTAMP DEFAULT current_timestamp
);

DROP TABLE IF EXISTS packageType;
CREATE TABLE packageType (

	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
	id    INT(10) ,
	type  VARCHAR(50) ,
	count INT

);

DROP TABLE IF EXISTS packagStatus;
CREATE TABLE packageStatus (

	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
	type  VARCHAR(50) ,
	count INT,
	created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ,
	updated_at TIMESTAMP DEFAULT current_timestamp
);
