Bay Enity - POSOCO/wrldc_warehouse_data_migration_python GitHub Wiki
BAY
select ID, VOLTAGE_ID, STATION_ID, BAY_TYPE_ID, SOURCE_ID, SOURCE_ENTITY, DESTINATION_ID, DESTINATION_ENTITY, BAY_NUMBER, CREATED_BY, CREATED_DATE, MODIFIED_BY, MODIFIED_DATE, SOURCE_ENTITY_TYPE, DESTINATION_ENTITY_TYPE, BAY_NAME from REPORTING_WEB_UI_UAT.BAY where 1=1
| name |
type |
nullable |
| ID |
NUMBER |
Yes |
| VOLTAGE_ID |
NUMBER |
Yes |
| STATION_ID |
NUMBER |
Yes |
| BAY_TYPE_ID |
NUMBER |
Yes |
| SOURCE_ID |
NUMBER |
Yes |
| SOURCE_ENTITY |
VARCHAR2(200 BYTE) |
Yes |
| DESTINATION_ID |
NUMBER |
Yes |
| DESTINATION_ENTITY |
VARCHAR2(200 BYTE) |
Yes |
| BAY_NUMBER |
VARCHAR2(100 BYTE) |
Yes |
| CREATED_BY |
VARCHAR2(200 BYTE) |
Yes |
| CREATED_DATE |
DATE |
Yes |
| MODIFIED_BY |
VARCHAR2(200 BYTE) |
Yes |
| MODIFIED_DATE |
DATE |
Yes |
| SOURCE_ENTITY_TYPE |
VARCHAR2(100 BYTE) |
Yes |
| DESTINATION_ENTITY_TYPE |
VARCHAR2(100 BYTE) |
Yes |
| BAY_NAME |
VARCHAR2(500 BYTE) |
Yes |
BAY_TYPE
select ID, TYPE from REPORTING_WEB_UI_UAT.BAY_TYPE where 1=1
| name |
type |
nullable |
| ID |
NUMBER |
No |
| TYPE |
VARCHAR2(100 BYTE) |
Yes |