sqloracle

type BlockKeywordType int

type ColumnExpressionInfo struct {
	ColumnName       string `db:"COLUMN_NAME"`
	IndexName        string `db:"INDEX_NAME"`
	ColumnExpression string `db:"COLUMN_EXPRESSION"`
}

type ColumnInfo struct {
	ColumnName    string         `db:"COLUMN_NAME"`
	DataType      string         `db:"DATA_TYPE"`
	DataLength    sql.NullInt64  `db:"DATA_LENGTH"`
	CharLength    sql.NullInt64  `db:"CHAR_LENGTH"`
	DataPrecision sql.NullInt64  `db:"DATA_PRECISION"`
	DataScale     sql.NullInt64  `db:"DATA_SCALE"`
	Nullable      string         `db:"NULLABLE"`
	CharUsed      sql.NullString `db:"CHAR_USED"`
	DataDefault   sql.NullString `db:"DATA_DEFAULT"`
	Comment       sql.NullString `db:"COMMENTS"`
}

type CommentInfo struct {
	ColumnName string `db:"COLUMN_NAME"`
	Comments   string `db:"COMMENTS"`
}

type ConstraintInfo struct {
	ConstraintName  string         `db:"CONSTRAINT_NAME"`
	ConstraintType  string         `db:"CONSTRAINT_TYPE"` // 'P':主键, 'R':外键, 'U':唯一, 'C':检查
	ColumnName      string         `db:"COLUMN_NAME"`
	Position        *int           `db:"POSITION"`
	RConstraintName sql.NullString `db:"R_CONSTRAINT_NAME"`
	DeleteRule      sql.NullString `db:"DELETE_RULE"`
	SearchCondition sql.NullString `db:"SEARCH_CONDITION"`
}

type IndexInfo struct {
	IndexName      string `db:"INDEX_NAME"`
	ColumnName     string `db:"COLUMN_NAME"`
	ColumnPosition int    `db:"COLUMN_POSITION"`
	Uniqueness     string `db:"UNIQUENESS"`
	Descend        string `db:"DESCEND"` // ASC or DESC
}

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

type OracleType int

type RefConstraintInfo struct {
	RConstraintName string `db:"R_CONSTRAINT_NAME"`
	TableName       string `db:"TABLE_NAME"`
	Owner           string `db:"OWNER"`
}

type SequenceInfo struct {
	SequenceName  string `db:"SEQUENCE_NAME"`
	MinValue      string `db:"MIN_VALUE"`
	MaxValue      string `db:"MAX_VALUE"`
	IncrementBy   string `db:"INCREMENT_BY"`
	CycleFlag     string `db:"CYCLE_FLAG"`
	OrderFlag     string `db:"ORDER_FLAG"`
	CacheSize     string `db:"CACHE_SIZE"`
	LastNumber    string `db:"LAST_NUMBER"`
	SequenceOwner string `db:"SEQUENCE_OWNER"`
}

type Trigger struct {
	Owner            string         `db:"OWNER"`
	TriggerName      string         `db:"TRIGGER_NAME"`
	TriggerType      string         `db:"TRIGGER_TYPE"`
	TriggeringEvent  string         `db:"TRIGGERING_EVENT"`
	TableOwner       string         `db:"TABLE_OWNER"`
	BaseObjectType   string         `db:"BASE_OBJECT_TYPE"`
	TableName        string         `db:"TABLE_NAME"`
	ColumnName       sql.NullString `db:"COLUMN_NAME"`
	ReferencingNames string         `db:"REFERENCING_NAMES"`
	WhenClause       sql.NullString `db:"WHEN_CLAUSE"`
	Status           string         `db:"STATUS"`
	Description      string         `db:"DESCRIPTION"`
	ActionType       string         `db:"ACTION_TYPE"`
	TriggerBody      string         `db:"TRIGGER_BODY"`
	Crosession       string         `db:"CROSSEDITION"`
	BeforeStatement  string         `db:"BEFORE_STATEMENT"`
	BeforeRow        string         `db:"BEFORE_ROW"`
	AfterRow         string         `db:"AFTER_ROW"`
	AfterStatement   string         `db:"AFTER_STATEMENT"`
	InsteadOfRow     string         `db:"INSTEAD_OF_ROW"`
	FireOnce         string         `db:"FIRE_ONCE"`
	ApplyServerOnly  string         `db:"APPLY_SERVER_ONLY"`
}

type TriggerInfo struct {
	TriggerName  string `db:"TRIGGER_NAME"`
	TriggerType  string `db:"TRIGGER_TYPE"`
	TriggerEvent string `db:"TRIGGER_EVENT"`
	TriggerBody  string `db:"TRIGGER_BODY"`
}