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)