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