Editing HR.LOCATIONS (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
− | |- | + | |- |
| '''Table | | '''Table | ||
| HR.LOCATIONS | | HR.LOCATIONS | ||
Line 11: | Line 11: | ||
locations of customers. Contains 23 rows; references with the | locations of customers. Contains 23 rows; references with the | ||
departments and countries tables. | departments and countries tables. | ||
+ | |- | ||
|} | |} | ||
+ | |||
=== Columns === | === Columns === | ||
Line 21: | Line 23: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- |
| LOCATION_ID | | LOCATION_ID | ||
| NUMBER(4, 0) | | NUMBER(4, 0) | ||
Line 28: | Line 30: | ||
| | | | ||
| Primary key of locations table | | Primary key of locations table | ||
− | |- | + | |- |
| STREET_ADDRESS | | STREET_ADDRESS | ||
| VARCHAR2(40) | | VARCHAR2(40) | ||
Line 35: | Line 37: | ||
| Street address of an office, warehouse, or production site of a company. | | Street address of an office, warehouse, or production site of a company. | ||
Contains building number and street name | Contains building number and street name | ||
− | |- | + | |- |
| POSTAL_CODE | | POSTAL_CODE | ||
| VARCHAR2(12) | | VARCHAR2(12) | ||
Line 42: | Line 44: | ||
| Postal code of the location of an office, warehouse, or production site | | Postal code of the location of an office, warehouse, or production site | ||
of a company. | of a company. | ||
− | |- | + | |- |
| CITY | | CITY | ||
| VARCHAR2(30) | | VARCHAR2(30) | ||
Line 49: | Line 51: | ||
| A not null column that shows city where an office, warehouse, or | | A not null column that shows city where an office, warehouse, or | ||
production site of a company is located. | production site of a company is located. | ||
− | |- | + | |- |
| STATE_PROVINCE | | STATE_PROVINCE | ||
| VARCHAR2(25) | | VARCHAR2(25) | ||
Line 56: | Line 58: | ||
| State or Province where an office, warehouse, or production site of a | | State or Province where an office, warehouse, or production site of a | ||
company is located. | company is located. | ||
− | |- | + | |- |
| COUNTRY_ID | | COUNTRY_ID | ||
| CHAR(2) | | CHAR(2) | ||
Line 70: | Line 72: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
− | |- | + | |- |
| LOC_ID_PK | | LOC_ID_PK | ||
| LOCATION_ID | | LOCATION_ID | ||
Line 81: | Line 83: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
− | + | ||
− | |- | + | |- |
− | | | + | | LOC_STATE_PROVINCE_IX |
| | | | ||
− | | | + | | STATE_PROVINCE |
− | |- | + | |- |
| LOC_COUNTRY_IX | | LOC_COUNTRY_IX | ||
| | | | ||
| COUNTRY_ID | | COUNTRY_ID | ||
− | |- | + | |- |
− | | | + | | LOC_CITY_IX |
| | | | ||
− | | | + | | CITY |
|} | |} | ||
Line 102: | Line 104: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
− | + | ||
− | |- | + | |- |
| LOC_CITY_NN | | LOC_CITY_NN | ||
| "CITY" IS NOT NULL | | "CITY" IS NOT NULL | ||
Line 115: | Line 117: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
− | + | ||
− | |- | + | |- |
| [[HR.COUNTRIES_(table)|HR.COUNTRIES]] | | [[HR.COUNTRIES_(table)|HR.COUNTRIES]] | ||
| COUNTRY_ID | | COUNTRY_ID | ||
Line 128: | Line 130: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
− | + | ||
− | |- | + | |- |
| [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]] | | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]] | ||
| LOCATION_ID | | LOCATION_ID | ||
| LOCATION_ID | | LOCATION_ID | ||
− | |- | + | |- |
| [[OE.WAREHOUSES_(table)|OE.WAREHOUSES]] | | [[OE.WAREHOUSES_(table)|OE.WAREHOUSES]] | ||
| LOCATION_ID | | LOCATION_ID | ||
| LOCATION_ID | | LOCATION_ID | ||
|} | |} |