COMPANIES
| Documentation | Projects database |
| Name | COMPANIES |
| Module | Organization and HR |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | COMPANY_ID | NUMBER | ||||||
| 2 | NAME | VARCHAR2(150 BYTE) | ||||||
| 3 | ADDRESS_1 | VARCHAR2(500 BYTE) | ||||||
| 4 | ADDRESS_2 | VARCHAR2(500 BYTE) | ||||||
| 5 | CITY | VARCHAR2(50 BYTE) | ||||||
| 6 | POSTAL_CODE | VARCHAR2(50 BYTE) | ||||||
| 7 | STATE | VARCHAR2(50 BYTE) | ||||||
| 8 | COUNTRY | VARCHAR2(50 BYTE) | ||||||
| 9 | PHONE | VARCHAR2(30 BYTE) | ||||||
| 10 | VARCHAR2(100 BYTE) | |||||||
| 11 | WEBSITE | VARCHAR2(100 BYTE) | ||||||
| 12 | COMPANY_TYPE_ID | NUMBER | ||||||
| 13 | INDUSTRY_ID | NUMBER | ||||||
| 14 | CREATED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 15 | CREATED_BY | NUMBER | ||||||
| 16 | MODIFIED_DATE | DATE | Default: SYSDATE | |||||
|
Default:
SYSDATE |
||||||||
| 17 | MODIFIED_BY | NUMBER | ||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| ACTIVITIES | COMPANIES | ACTIVITIES.ASSIGNED_TO_SUPPLIER_ID = COMPANIES.COMPANY_ID | FK_ACTIVITIES_SUPPLIER | |
|
ACTIVITIES.ASSIGNED_TO_SUPPLIER_ID = COMPANIES.COMPANY_ID Name: FK_ACTIVITIES_SUPPLIER |
||||
| CST_PROJECT_COSTS | COMPANIES | CST_PROJECT_COSTS.SUPPLIER_ID = COMPANIES.COMPANY_ID | FK_CST_PROJECT_COSTS_SUPPLIER | |
|
CST_PROJECT_COSTS.SUPPLIER_ID = COMPANIES.COMPANY_ID Name: FK_CST_PROJECT_COSTS_SUPPLIER |
||||
| PROJECTS | COMPANIES | PROJECTS.CUST_ID = COMPANIES.COMPANY_ID | FK_PROJECTS_CUSTOMER | |
|
PROJECTS.CUST_ID = COMPANIES.COMPANY_ID Name: FK_PROJECTS_CUSTOMER |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| COMPANIES_PK | COMPANY_ID |
Used by
| Name |
|---|
|
COMPANIES
|
Exported: 2019-02-04 22:52, Last imported: 2019-02-03 01:50