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