ddl

type Column struct {

	// Unique column name within a table
	Name string

	// Generic data type definition
	Type DataType

	// Internal name of the data type (with lenght)
	InternalType string

	// Weather this column is a primary key of the table
	PrimaryKey bool

	// Weather this column references another table
	ForeignKey bool
	// Table to which this column has a reference to
	ForeignKeyColumn ForeignColumn

	// Weather this column can be null
	CanBeNull bool

	// A default value of the column
	DefaultValue sql.NullString

	// Comment of this column
	Comment string

	// Extras
	Extras Columner
}

type Columner interface {

	// GetExtraInfos returns a string with additional properties that is passed
	// to the struct tag "Db" when using the struct generator
	GetExtraInfos() string

	// GetSpecificInfos returns the underlaying
	GetSpecificInfos() any
}

type DataType string

type DbSystem interface {

	// GetTable returns a single table identified by the schema and name
	GetTable(schema, name string) (*Table, error)

	// GeTables returns a list of tables that are present in the provided schema
	// or database
	GetTables(schema string) ([]*Table, error)
}

type ForeignColumn struct {

	// Name of the referenced table
	Name string

	// Schema or database the table belongs to
	Schema string

	// Name of the column that is referenced
	Column string
}

type Location struct {
	Longitude float64
	Latitude  float64
}

type Mariadb struct {
	// contains filtered or unexported fields
}

type MariadbColumn struct {
	*Column

	// Weather this column has the auto_increment flag
	AutoIncrement bool

	// The character lenght or numeric precision
	DataTypeLenght int

	// The internal column key like 'UNI' or 'PRI'
	KeyType MariadbKeyType
}

type MariadbKeyType string

type OracleColumn struct {
	*Column

	// Weather this column has the auto_increment flag
	AutoIncrement bool

	// Character lenght or numeric precision on the LEFT side
	// of the dot
	DataTypeLenght int

	// Decimal precision on the RIGHT side of the dot
	Scale int
}

type OracleDb struct {
	// contains filtered or unexported fields
}

type OracleTableType string

type Table struct {

	// Name of the table
	Name string

	// Schema or database the table belongs to
	Schema string

	// List of columns the table has
	Columns []*Column
}