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)