HR
Tables (4)
COUNTRIES (나라정보)
- COUNTRY_ID (Key) — VARCHAR2 — Primary key — NOT NULL
- REGION_ID (Key2) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
- COUNTRY_NAME (Field) — VARCHAR2
- REGION_ID (Field2) — NUMBER
DEPARTMENTS (Untitled2)
- DEPARTMENT_ID (Key) — NUMBER — Primary key — NOT NULL
- Field
LOCATIONS (Untitled)
- LOCATION_ID (Key) — NUMBER — Primary key — NOT NULL
- COUNTRY_ID (Key2) — VARCHAR2 — Foreign key → COUNTRIES.COUNTRY_ID — NOT NULL
- STREET_ADDRESS (Field) — VARCHAR2
- POSTAL_CODE (Field2) — VARCHAR2
- CITY (Field3) — VARCHAR2
- STATE_PROVINCE (Field4) — VARCHAR2
REGIONS (대륙정보)
- REGION_ID (Key) — NUMBER — Primary key — NOT NULL
- REGION_NAME (Field) — VARCHAR2