test

Tables (4)

location

  • location_pk — int(11) — Primary key — NOT NULL
  • location_content — varchar(50)
  • site_pk — int(11) — Foreign key → site.site_pk

report

  • report_pk — int(11) — Primary key — NOT NULL
  • report_content — int(11) — NOT NULL
  • site_pk — int(11) — Foreign key → site.site_pk — NOT NULL

report_location

  • report_pk — int(11) — Foreign key → report.report_pk
  • location_pk — int(11) — Foreign key → location.location_pk

site

  • site_pk — int(11) — Primary key — NOT NULL
  • site_name — int(11)