test_db
Tables (4)
REGIONS
- Key (REGION_ID) — varchar(2) — Primary key — NOT NULL
- Field (REGION_NAME) — varchar(30)
Untitled (COUNTRIES)
- Key (COUNTRY_ID) — varchar(2) — Primary key — NOT NULL
- Key (REGION_ID) — varchar(2) — Foreign key → REGIONS.Key — NOT NULL
- Field (COUNTRY_NAME) — varchar(30)
Untitled (EMPLOYEE)
- Key (EMPLOYEE_ID) — int — Primary key — NOT NULL
- Key (JOB_ID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (COUNTRY_ID) — varchar(2) — Foreign key → Untitled.Key — NOT NULL
- Key (REGION_ID) — varchar(2) — Foreign key → Untitled.Key — NOT NULL
- Field (FIRST_NAME) — varchar(20)
- Field (LAST_NAME) — varchar(20)
- Field (EMAIL) — varchar(30)
- Field (PHONE) — varchar(15)
- Field (HIRE_DATE) — date
- Field (MANAGER_ID) — int
Untitled (JOB)
- Key (JOB_ID) — int — Primary key — NOT NULL
- Field (JOB_NAME) — varchar(30)