pilot

Tables (3)

keyword_sector (2)

  • keyword (1) — varchar — Primary key
  • sector (2) — varchar — Primary key

like_to

  • lno — bigint — Primary key
  • pno — bigint — NOT NULL
  • uno — bigint — NOT NULL

prospect (1)

  • cumulative_time (1) — timestamp — Primary key
  • hcode (2) — varchar — Primary key
  • query (3) — varchar — Primary key
  • sector (4) — varchar — Primary key — NOT NULL
  • queryCount (5) — bigint — NOT NULL