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