Forum Discussion

JonKunert's avatar
JonKunert
Contributor III
1 month ago

Application database data model

Just looking for an Application database data model,  to help figure out how tables join together. Has anyone come across such a document, or created one that wouldn't mind sharing?.   I have never found one in the OS documentation    

Metadata

1 Reply

  • dsebenaler's avatar
    dsebenaler
    New Contributor III
    1 month ago

    You can use a SQL data adapter to return schema information via a grid view component. Alternatively, you can inspect the app db schema using the Table Data Manager (TDM) solution. 

    SELECT
    t.TABLE_SCHEMA,
    t.TABLE_NAME,
    c.COLUMN_NAME,
    c.ORDINAL_POSITION,
    c.DATA_TYPE,
    c.CHARACTER_MAXIMUM_LENGTH,
    c.NUMERIC_PRECISION,
    c.NUMERIC_SCALE,
    c.IS_NULLABLE,
    c.COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.TABLES t
INNER JOIN INFORMATION_SCHEMA.COLUMNS c
    ON t.TABLE_NAME   = c.TABLE_NAME
    AND t.TABLE_SCHEMA = c.TABLE_SCHEMA
WHERE t.TABLE_TYPE = 'BASE TABLE'
ORDER BY t.TABLE_NAME, c.ORDINAL_POSITION;