search

mk0 / infectionchain_tracking

DevPost
https://devpost.com/software/infection-chain
Creative Commons Attribution 4.0 International
4 stars 0 forks source link

DB Model - Contact_Travel_History #5

Open cpuell opened 4 years ago

cpuell commented 4 years ago

Script Example:

CREATE TABLE contact_travel_history ( id varchar(32) NOT NULL, city_name varchar(32) NOT NULL, country_id varchar(32) NOT NULL, date_travel_from datetime DEFAULT NULL, date_travel_to datetime DEFAULT NULL, date_create timestamp NULL DEFAULT CURRENT_TIMESTAMP, date_create_timezone varchar(255) DEFAULT NULL, date_update datetime DEFAULT NULL, date_update_timezone varchar(255) DEFAULT NULL, note varchar(250) DEFAULT NULL, is_delete bit(1) NOT NULL DEFAULT b'0', is_enabled bit(1) NOT NULL DEFAULT b'1', user_create varchar(32) DEFAULT NULL, user_update varchar(32) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

mk0 commented 4 years ago

Wofür brauchen wir diese Daten? Haben wir momentan noch nicht in Verwendung.