relational-schemas-0.1.3.1: RDBMSs' schema templates for relational-query

Copyright	2013 Kei Hibino
License	BSD3
Maintainer	ex8k.hibino@gmail.com
Stability	experimental
Portability	unknown
Safe Haskell	None
Language	Haskell2010

Database.Relational.Schema.DB2Syscat.Columns

Description

Generate template of SYSCAT.columns system catalog table.

Documentation

data Columns Source

Constructors

Fields

tabschema :: !String
tabname :: !String
colname :: !String
colno :: !Int16
typeschema :: !String
typename :: !String
length :: !Int32
scale :: !Int16
default_ :: !(Maybe String)
nulls :: !String
codepage :: !Int16
logged :: !String
compact :: !String
colcard :: !Int64
high2key :: !(Maybe String)
low2key :: !(Maybe String)
avgcollen :: !Int32
keyseq :: !(Maybe Int16)
partkeyseq :: !(Maybe Int16)
nquantiles :: !Int16
nmostfreq :: !Int16
numnulls :: !Int64
targetTypeschema :: !(Maybe String)
targetTypename :: !(Maybe String)
scopeTabschema :: !(Maybe String)
scopeTabname :: !(Maybe String)
sourceTabschema :: !(Maybe String)
sourceTabname :: !(Maybe String)
dlFeatures :: !(Maybe String)
specialProps :: !(Maybe String)
hidden :: !String
inlineLength :: !Int32
identity :: !String
generated :: !String
text :: !(Maybe String)
remarks :: !(Maybe String)

Instances

Show Columns Source
PersistableWidth Columns Source
TableDerivable Columns Source
ProductConstructor (String -> String -> String -> Int16 -> String -> String -> Int32 -> Int16 -> Maybe String -> String -> Int16 -> String -> String -> Int64 -> Maybe String -> Maybe String -> Int32 -> Maybe Int16 -> Maybe Int16 -> Int16 -> Int16 -> Int64 -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> Maybe String -> String -> Int32 -> String -> String -> Maybe String -> Maybe String -> Columns) Source

remarks' :: Pi Columns (Maybe String) Source

text' :: Pi Columns (Maybe String) Source

generated' :: Pi Columns String Source

identity' :: Pi Columns String Source

inlineLength' :: Pi Columns Int32 Source

hidden' :: Pi Columns String Source

specialProps' :: Pi Columns (Maybe String) Source

dlFeatures' :: Pi Columns (Maybe String) Source

sourceTabname' :: Pi Columns (Maybe String) Source

sourceTabschema' :: Pi Columns (Maybe String) Source

scopeTabname' :: Pi Columns (Maybe String) Source

scopeTabschema' :: Pi Columns (Maybe String) Source

targetTypename' :: Pi Columns (Maybe String) Source

targetTypeschema' :: Pi Columns (Maybe String) Source

numnulls' :: Pi Columns Int64 Source

nmostfreq' :: Pi Columns Int16 Source

nquantiles' :: Pi Columns Int16 Source

partkeyseq' :: Pi Columns (Maybe Int16) Source

keyseq' :: Pi Columns (Maybe Int16) Source

avgcollen' :: Pi Columns Int32 Source

low2key' :: Pi Columns (Maybe String) Source

high2key' :: Pi Columns (Maybe String) Source

colcard' :: Pi Columns Int64 Source

compact' :: Pi Columns String Source

logged' :: Pi Columns String Source

codepage' :: Pi Columns Int16 Source

nulls' :: Pi Columns String Source

default' :: Pi Columns (Maybe String) Source

scale' :: Pi Columns Int16 Source

length' :: Pi Columns Int32 Source

typename' :: Pi Columns String Source

typeschema' :: Pi Columns String Source

colno' :: Pi Columns Int16 Source

colname' :: Pi Columns String Source

tabname' :: Pi Columns String Source

tabschema' :: Pi Columns String Source

insertQueryColumns :: forall p. Relation p Columns -> InsertQuery p Source

insertColumns :: Insert Columns Source

columns :: Relation () Columns Source

tableOfColumns :: Table Columns Source

columnOffsetsColumns :: Array Int Int Source