test4

Tables (4)

country

  • id — int — Primary key — NOT NULL
  • name — varchar(100)
  • currency — double

job

  • id — int — Primary key — NOT NULL
  • name — varchar(100)
  • credit — double
  • pay — int

person

  • id — int — Primary key — NOT NULL
  • name — varchar(100)
  • age — int
  • country_id — int — NOT NULL

person_job_map

  • person_id — int — Foreign key → person.id — NOT NULL
  • job_id — int — Foreign key → job.id — NOT NULL