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" |
− | |- valign="top" | + | |- |
− | | '''Table | + | | '''table |
| | HR.LOCATIONS | | | HR.LOCATIONS |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Locations table that contains specific address of a specific office,
| |
− | warehouse, and/or production site of a company. Does not store addresses /
| |
− | locations of customers. Contains 23 rows; references with the
| |
− | departments and countries tables.
| |
− | |}
| |
− | | |
− | === Columns ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description
| |
− | | |
− | |- valign="top"
| |
− | | LOCATION_ID
| |
− | | NUMBER(4, 0)
| |
− | | not null
| |
− | |
| |
− | | Primary key of locations table
| |
− | |- valign="top"
| |
− | | STREET_ADDRESS
| |
− | | VARCHAR2(40)
| |
− | | null
| |
− | |
| |
− | | Street address of an office, warehouse, or production site of a company.
| |
− | Contains building number and street name
| |
− | |- valign="top"
| |
− | | POSTAL_CODE
| |
− | | VARCHAR2(12)
| |
− | | null
| |
− | |
| |
− | | Postal code of the location of an office, warehouse, or production site
| |
− | of a company.
| |
− | |- valign="top"
| |
− | | CITY
| |
− | | VARCHAR2(30)
| |
− | | not null
| |
− | |
| |
− | | A not null column that shows city where an office, warehouse, or
| |
− | production site of a company is located.
| |
− | |- valign="top"
| |
− | | STATE_PROVINCE
| |
− | | VARCHAR2(25)
| |
− | | null
| |
− | |
| |
− | | State or Province where an office, warehouse, or production site of a
| |
− | company is located.
| |
− | |- valign="top"
| |
− | | COUNTRY_ID
| |
− | | CHAR(2)
| |
− | | null
| |
− | |
| |
− | | Country where an office, warehouse, or production site of a company is
| |
− | located. Foreign key to country_id column of the countries table.
| |
− | |}
| |
− | | |
− | === Primary Key ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Primary Key
| |
− | | '''Columns
| |
− | |- valign="top"
| |
− | | LOC_ID_PK
| |
− | | LOCATION_ID
| |
− | |}
| |
− | | |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− | | |
− | |- valign="top"
| |
− | | LOC_CITY_IX
| |
− | |
| |
− | | CITY
| |
− | |- valign="top"
| |
− | | LOC_COUNTRY_IX
| |
− | |
| |
− | | COUNTRY_ID
| |
− | |- valign="top"
| |
− | | LOC_STATE_PROVINCE_IX
| |
− | |
| |
− | | STATE_PROVINCE
| |
− | |}
| |
− | | |
− | === Check Constraints ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Check Constraint
| |
− | | '''Expression
| |
− | | '''Description
| |
− | | |
− | |- valign="top"
| |
− | | LOC_CITY_NN
| |
− | | "CITY" IS NOT NULL
| |
− | |
| |
− | |}
| |
− | | |
− | === Foreign Keys ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Relation
| |
− | | '''Column
| |
− | | '''Referenced Column
| |
− | | |
− | |- valign="top"
| |
− | | [[HR.COUNTRIES_(table)|HR.COUNTRIES]]
| |
− | | COUNTRY_ID
| |
− | | COUNTRY_ID
| |
− | |}
| |
− | | |
− | === Detail Tables ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Detail Table
| |
− | | '''Column
| |
− | | '''Referencing Column
| |
− | | |
− | |- valign="top"
| |
− | | [[HR.DEPARTMENTS_(table)|HR.DEPARTMENTS]]
| |
− | | LOCATION_ID
| |
− | | LOCATION_ID
| |
− | |- valign="top"
| |
− | | [[OE.WAREHOUSES_(table)|OE.WAREHOUSES]]
| |
− | | LOCATION_ID
| |
− | | LOCATION_ID
| |
| |} | | |} |