 
 DROP TABLE IF EXISTS postOffice;
 CREATE TABLE postOffice (
-	-- 	id does not have attribute constraints.
-	-- See roles(id)
-	id         INT(10) ,
+
+	id         INT(10) UNSIGNED PRIMARY KEY AUTO_INCREMENT ,
 	name       VARCHAR(50) ,
 	address    VARCHAR(50) ,
 	city       VARCHAR(50) ,


DROP TABLE IF EXISTS packages;
CREATE TABLE packages (
	-- 	id does not have attribute constraints.
	-- See roles(id)
	id             INT(10)      NOT NULL ,
	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
	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
	contents       VARCHAR(255) ,
	weight         DOUBLE ,
	priority       BOOL ,


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
);
