2020_0526-DeepSignal_v_0_1 - 2020-06-03 08:51:10
Tables (10)
Untitled
- project_id (Key) — varchar(32) — Primary key — NOT NULL
- index_name (Field2) — varchar(50) — NOT NULL
- published_at_from (Field3) — DATETIME — NOT NULL
- Field
code_language
- language — varchar(20) — Primary key — NOT NULL
- description — varchar(512)
code_service_section
- service_section — varchar(25) — Primary key — NOT NULL
- code_order — tinyint(2) — NOT NULL — For Display UI
- is_disabled — tinyint(1) — NOT NULL
- description — varchar(45)
- registered_at — datetime — NOT NULL
code_service_type
- service_type — varchar(20) — Primary key — NOT NULL
- code_order — tinyint(2) — NOT NULL
- is_disabled — tinyint(1) — NOT NULL
- description — varchar(512)
- registered_at — datetime — NOT NULL
code_table
- code — varchar(50) — Primary key — NOT NULL — NEWS\nBLOG\nARTICLE\nINSTAGRAM\nFACEBOOK\nTWITTER\nLINKEDIN
- code_group — varchar(50) — Primary key — NOT NULL
- code_name — varchar(50) — NOT NULL
- code_order — tinyint(2) — NOT NULL — For Display UI
- is_disabled — tinyint(1) — NOT NULL
- description — varchar(512)
- registered_at — datetime — NOT NULL
company
- company_id — varchar(32) — Primary key — NOT NULL
- company_name — varchar(256) — NOT NULL
- last_updated_at — datetime — NOT NULL
- registered_at — datetime — NOT NULL
project
- project_id — varchar(32) — Primary key — NOT NULL
- company_id — varchar(32) — Foreign key → company.company_id — NOT NULL
- project_name — varchar(256) — NOT NULL
- searvice_data_from — date
- service_data_to — date
- is_closed — tinyint(4) — NOT NULL
- description — varchar(512)
project_web_source
- project_id — varchar(32) — Foreign key → project.project_id — NOT NULL
- web_source_id — varchar(32) — Foreign key → web_source.web_source_id — NOT NULL
- registered_at — datetime — NOT NULL
web_source
- web_source_id — varchar(32) — Primary key — NOT NULL
- web_url — varchar(256) — NOT NULL
- service_type — varchar(20) — Foreign key → code_service_type.service_type — NOT NULL
- service_language — varchar(20) — Foreign key → code_language.language
- category — varchar(256) — keyword list by comma
- condition — varchar(512) — QUERY=\nKEY1=VALUE1\nKEY2=VALUE2
- is_attachment — tinyint(1) — NOT NULL
- is_comment — tinyint(1) — NOT NULL
- last_updated_at — datetime — NOT NULL
- registered_at — datetime — NOT NULL
web_source_statistics
- web_source_id — varchar(32) — Foreign key → web_source.web_source_id — NOT NULL
- published_date — date — NOT NULL
- number_of_collection — int(11) — NOT NULL