| 1 | export interface IDatabaseColumn {
|
| 2 | "extra": string;
|
| 3 | "default"?: any;
|
| 4 | "key": string;
|
| 5 | "null": string | boolean;
|
| 6 | "type": string;
|
| 7 | "field": string;
|
| 8 | "enumValues": string[] | null;
|
| 9 | "length": number;
|
| 10 | "isPrimary": boolean;
|
| 11 | "index": number;
|
| 12 | }
|
| 13 | export interface IDatabaseTable {
|
| 14 | [columnName: string]: IDatabaseColumn;
|
| 15 | }
|
| 16 | export interface ITableDictionary {
|
| 17 | [table: string]: IDatabaseTable;
|
| 18 | }
|
| 19 | export interface IStoredProcedureDictionary {
|
| 20 | [sp: string]: IStoredProcedure;
|
| 21 | }
|
| 22 | export interface IStoredProcedureParameter {
|
| 23 | specificName: string;
|
| 24 | ordinalPosition: number;
|
| 25 | parameterMode: string;
|
| 26 | parameterName: string;
|
| 27 | dataType: string;
|
| 28 | characterMaximumLength: number | null;
|
| 29 | characterOctetLength: number | null;
|
| 30 | numericPrecision: number;
|
| 31 | numericScale: number;
|
| 32 | datetimePrecision: any;
|
| 33 | characterSetName: string | null;
|
| 34 | collationName: string | null;
|
| 35 | dtdIdentifier: string;
|
| 36 | specificCatalog: string;
|
| 37 | specificSchema: string;
|
| 38 | }
|
| 39 | export interface IStoredProcedure {
|
| 40 | name: string;
|
| 41 | parameters: {
|
| 42 | [param: string]: IStoredProcedureParameter;
|
| 43 | };
|
| 44 | }
|
| 45 | export interface IDatabaseSchema {
|
| 46 | tables: ITableDictionary;
|
| 47 | views: ITableDictionary;
|
| 48 | storedProcedures: IStoredProcedureDictionary;
|
| 49 | }
|