KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - DATABASECHANGELOG link

Properties
Name Value
Data Model Physical
Schema dbo
Primary Key Clustered Unspecified
Unlogged false
Temporal false

Columns Summary
Column Name Data Type PK / FK Nullable Description
ID varchar2(255) Yes
AUTHOR varchar2(255) Yes
FILENAME varchar2(255) Yes
DATEEXECUTED date Yes
ORDEREXECUTED number(0) Yes
EXECTYPE varchar2(10) Yes
MD5SUM varchar2(35) Yes
DESCRIPTION varchar2(255) Yes
COMMENTS varchar2(255) Yes
TAG varchar2(255) Yes
LIQUIBASE varchar2(20) Yes

Columns Detail
Name Value
Name ID
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name AUTHOR
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name FILENAME
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name DATEEXECUTED
Type date
Nullable true
Unique false
Primary Key false
Index false
Type Name datetime2
Length 6
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name ORDEREXECUTED
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name bigint
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name EXECTYPE
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name MD5SUM
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 35
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name DESCRIPTION
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name COMMENTS
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name TAG
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LIQUIBASE
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 20
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Appears In
Diagram
 KDOT_RPMS_Modeling(Reduced) : Entity Relationship Diagram
KDOT PMS Replacement Project