HR_ERD

Tables (3)

countries

  • country_id — CHAR(2) — Primary key — NOT NULL
  • country_name — VARCHAR2(40)
  • region_id — NUMBER

locations

  • location_id — NUMBER(4)
  • street_address — VARCHAR2(40)
  • postal_code — VARCHAR2(12)
  • city — VARCHAR2(30) — NOT NULL
  • state_province — VARCHAR2(25)
  • country_id — CHAR(2)

regions

  • region_id — NUMBER — NOT NULL
  • region_name — VARCHAR2(25)