# TILSNA — Core Knowledge Database package

Contents
  sql/01_schema.sql        12 core tables (PostgreSQL DDL)
  sql/02_sample_data.sql   sample rows derived from the live portal data
  medias/research/*        research project images
  medias/researchers/*     researcher portraits
  medias/companies/*       company images
  medias/products/*        product images

Load (PostgreSQL)
  createdb tilsna_core
  psql -d tilsna_core -f sql/01_schema.sql
  psql -d tilsna_core -f sql/02_sample_data.sql

Media files map to the *_id of each row (e.g. medias/products/product-01.jpg → products.product_id = 1).
