Integrationsprojekt


user
- id INT 11 UNSIGNED PK
- first_name VC 255
- last_name VC 255
- phone VC 30
- email VC 255
- birthday DATE
- company_name VC 255
- user_roll ENUM ('Crowdworker','Crowdsourcer','Admin','Worker')
- password VC 255


////Produkt
- id INT 11 UNSIGNED PK
- produktname VC 255
- produktbeschreibung VC 1500
- produktklasse VC 255
-price_retail DOUBLE 6,2

Antragsverwaltung

Antrag
- id INT 11 UNSIGNED PK
- id_mitarbeiter INT 11 FK
- id_unternehmen INT 11 FK
- id_produkt	 INT 11 FK
- create_date	DATETIME
- deadline		DATETIME
- feedback_number INT 11
- verguetung DOUBLE 6,2

crowdworkerauftrag
 -id INT 11 UNSIGNED PK
 -antrag_id INT 11 UNSIGNED FK
 -mitarbeiter_id INT 11 UNSIGNED FK

 statusaenderung
 - id INT 11 UNSIGNED PK
 - time_stamp_der_aenderung DATETIME
 - typ_der_aenderung VC 1500
 - meta_daten VC 1500