database

type ColumnResult struct {
	Name     string
	DataType string
}

type Connector interface {
	Connect() error
	Close()
	GetDbType() DbType
	GetSchemas() ([]string, error)
	GetTables(schemaName string) ([]string, error)
	GetColumns(tableName string) ([]ColumnResult, error)
	GetConstraints(tableName string) ([]ConstraintResult, error)
}

type ConnectorFactory interface {
	NewConnector(connectionString string) (Connector, error)
}

type ConstraintResult struct {
	FkTable        string
	PKTable        string
	ConstraintName string
	IsPrimary      bool
	HasMultiplePK  bool
}

type ConstraintResultList []ConstraintResult

type DbType string

type Result struct {
	Tables []TableResult
}

type TableResult struct {
	TableName   string
	Columns     []ColumnResult
	Constraints ConstraintResultList
}