SchemaSpy Analysis of lingulog.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Apr 04 23:14 CEST 2016
Legend:
Primary key columns
Columns with indexes
 

lingulog.public contains 94 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
activity date timestamp 29,6
activity entity bpchar 32
activity id serial 10  √  nextval('lilo_activity_id_seq'::regclass)
activity index int4 10  √  null
activity meta text 2147483647  √  null
activity type int4 10 0
activity user_id int4 10
address address varchar 255  √  null
address city varchar 45  √  null
address company varchar 255  √  null
address country varchar 2  √  null
address fax varchar 255  √  null
address firstname varchar 255  √  null
address id serial 10  √  nextval('lilo_address_id_seq'::regclass)
address lastname varchar 255  √  null
address phone varchar 255  √  null
address state varchar 255  √  null
address vatid varchar 255  √  null
address website varchar 255  √  null
address zipcode varchar 45  √  null
comment date timestamp 29,6
comment id serial 10  √  nextval('lilo_comment_id_seq'::regclass)
comment language_id varchar 6  √  null
comment project_id int4 10
comment text text 2147483647
comment translation_field_id int4 10  √  null
comment type int2 5 0
comment user_id int4 10
invitation creationdate timestamp 29,6
invitation email varchar 255
invitation id serial 10  √  nextval('lilo_invitation_id_seq'::regclass)
invitation languages text 2147483647  √  null
invitation organization_id int4 10  √  null
invitation project_id int4 10  √  null
invitation role int2 5 0
language id varchar 6
language name varchar 255
organization address_id int4 10  √  null
organization email varchar 255
organization id serial 10  √  nextval('lilo_organization_id_seq'::regclass)
organization identifier varchar 45
organization name varchar 255
organization_user organization_id int4 10
organization_user role int2 5 0
organization_user user_id int4 10
progress id serial 10  √  nextval('lilo_progress_id_seq'::regclass)
progress language_id varchar 6  √  null
progress progress int4 10 0
progress project_id int4 10  √  null
progress translation_field_id int4 10  √  null
progress translation_group_id int4 10  √  null
project default_language_id varchar 6  √  null
project default_role int2 5 0
project description text 2147483647  √  null
project id serial 10  √  nextval('lilo_project_id_seq'::regclass)
project identifier varchar 45
project is_public int2 5 1
project name varchar 255
project organization_id int4 10  √  null
project_favourite project_id int4 10
project_favourite user_id int4 10
project_language language_id varchar 6
project_language project_id int4 10
project_task language_id varchar 6
project_task project_id int4 10
project_task user_id int4 10
project_user project_id int4 10
project_user role int2 5 0
project_user user_id int4 10
translation_field id serial 10  √  nextval('lilo_translation_field_id_seq'::regclass)
translation_field name varchar 255
translation_field project_id int4 10  √  null
translation_field translation_group_id int4 10  √  null
translation_field type int2 5 0
translation_group id serial 10  √  nextval('lilo_translation_group_id_seq'::regclass)
translation_group name varchar 255
translation_group project_id int4 10
translation_group translation_group_id int4 10  √  null
translation_value creationdate timestamp 29,6
translation_value id serial 10  √  nextval('lilo_translation_value_id_seq'::regclass)
translation_value language_id varchar 6
translation_value translation_field_id int4 10
translation_value user_id int4 10  √  null
translation_value value text 2147483647
user address_id int4 10  √  null
user email varchar 255
user firstname varchar 255  √  null
user id serial 10  √  nextval('lilo_user_id_seq'::regclass)
user lastname varchar 255  √  null
user password_hash varchar 255
user username varchar 30  √  null
user_language language_id varchar 6
user_language level int4 10 0
user_language user_id int4 10