abstime aclitem bfile bfloat4 bfloat8 bigint binary bit blob bool boolean box bpchar bytea char character character varying char varying cid cidr circle clob counter currency cursor date datetime decimal double double precision enum float float4 float8 identity image inet int int2 int2vector int4 int8 integer interval line long longbinary longblob longchar long raw longtext longvarbinary longvarchar long varchar lseg macaddr mediumblob mediumint mediumtext money name national char national character national character varying national char varying nchar nchar varying nclob ntext number numeric numericsa numericsts nvarchar nvarchar2 oid oidvector path point polygon raw real refcursor regproc reltime rowid set smalldatetime smallidentity smallint smallmoney smgr sql_variant text tid time timestamp timestamptz timetz tinterval tinyblob tinyint tinytext ubigint uinteger uniqueidentifier unknown urowid usmallint utinyint varbinary varbit varchar varchar2 xid xmltype year
table types
ER
check database FK identifying index key non-identifying not null null PK schema table trigger unique view