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