qroad1

Tables (11)

admins

  • id — bigserial
  • login_id — varchar(100) — NOT NULL
  • password — varchar(255) — NOT NULL
  • press_company — varchar(100)
  • status — varchar(20) — NOT NULL
  • (EXPIRED::character — varying)::text))
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

article_keywords

  • id — bigserial
  • article_id — bigint — NOT NULL
  • keyword_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

article_related

  • id — bigserial
  • article_id — bigint — NOT NULL
  • related_article_id — bigint — NOT NULL
  • score — double
  • batch_date — date — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

articles

  • id — bigserial
  • title — varchar(255) — NOT NULL
  • summary — text
  • link — text — NOT NULL
  • status — varchar(20) — NOT NULL
  • (EXPIRED::character — varying)::text))
  • reporter — varchar(100)
  • paper_id — bigint
  • admin_id — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • content — text

keywords

  • id — bigserial
  • name — varchar(100) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

papers

  • id — bigserial
  • published_date — date
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • status — varchar(20) — NOT NULL
  • (EXPIRED::character — varying)::text))
  • admin_id — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

policy

  • id — bigserial
  • title — text — NOT NULL
  • sub_title — text
  • content — text
  • minister_name — varchar(100)
  • original_url — text — NOT NULL
  • registration_date — timestamp
  • status — varchar(20) — NOT NULL
  • (EXPIRED::character — varying)::text))
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

policy_article_related

  • id — bigserial
  • article_id — bigint — NOT NULL
  • policy_id — bigint — NOT NULL
  • score — double
  • batch_date — date — NOT NULL
  • status — varchar(20) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

qr_codes

  • id — bigserial
  • qr_key — varchar(100) — NOT NULL
  • qr_image_url — varchar(255)
  • target_url — varchar(255) — NOT NULL
  • expires_at — timestamp
  • status — varchar(20) — NOT NULL
  • (EXPIRED::character — varying)::text))
  • paper_id — bigint
  • admin_id — bigint
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

vector_articles

  • id — bigserial
  • article_id — bigint — NOT NULL
  • title — text
  • published_date — date
  • vector — vector(1536) — NOT NULL
  • created_at — timestamp — NOT NULL

vector_policy

  • id — bigserial
  • policy_id — bigint — NOT NULL
  • title — text
  • vector — vector(1536) — NOT NULL
  • created_at — timestamp — NOT NULL