nasa_hackerton

Tables (5)

figure (논문 이미지)

  • id (Key) — bigint — Primary key — NOT NULL
  • url (Field) — TEXT
  • caption (Field2) — TEXT
  • research_id (Key2) — bigint — Foreign key → research.id — NOT NULL

hypothesis (가설)

  • id (Key) — bigint — Primary key — NOT NULL
  • status (Field) — varchar(255)
  • statement (Field2) — varchar(255)
  • usage (Field3) — TEXT
  • evidence (Field4) — TEXT
  • user_id (Field5) — bigint

hypothesis_researchs (가설 참고 논문 urls)

  • id (Key) — bigint — Primary key — NOT NULL
  • url (Field) — varchar(255)
  • hypothesis_id (Key2) — bigint — Foreign key → hypothesis.id — NOT NULL

research (연구논문)

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar(255)
  • journal (Field2) — varchar(255)
  • doi (Field3) — varchar(255)
  • author (Field4) — varchar(255)
  • release_date (Field5) — DATE
  • brief_summary (Field6) — varchar(255)
  • overall_summary (Field7) — TEXT
  • methods (Field8) — TEXT
  • results (Field9) — TEXT
  • pmc_id (Field10) — TEXT
  • Field11

research_gaps (연구 간극)

  • id (Key) — bigint — Primary key — NOT NULL
  • type (Field) — varchar(255)
  • content (Field2) — TEXT
  • evidence (Field3) — TEXT
  • research_title (Field4) — varchar(255)
  • research_id (Key2) — bigint — Foreign key → research.id — NOT NULL