Lingulog Schema Documentation

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
activity	entity	bpchar	32
project	default_role	int2	5			0
project	is_public	int2	5			1
invitation	role	int2	5			0
organization_user	role	int2	5			0
project_user	role	int2	5			0
comment	type	int2	5			0
translation_field	type	int2	5			0
organization	address_id	int4	10	√		null
user	address_id	int4	10	√		null
activity	index	int4	10	√		null
user_language	level	int4	10			0
invitation	organization_id	int4	10	√		null
organization_user	organization_id	int4	10
project	organization_id	int4	10	√		null
progress	progress	int4	10			0
comment	project_id	int4	10
invitation	project_id	int4	10	√		null
progress	project_id	int4	10	√		null
project_favourite	project_id	int4	10
project_language	project_id	int4	10
project_task	project_id	int4	10
project_user	project_id	int4	10
translation_field	project_id	int4	10	√		null
translation_group	project_id	int4	10
comment	translation_field_id	int4	10	√		null
progress	translation_field_id	int4	10	√		null
translation_value	translation_field_id	int4	10
progress	translation_group_id	int4	10	√		null
translation_field	translation_group_id	int4	10	√		null
translation_group	translation_group_id	int4	10	√		null
activity	type	int4	10			0
activity	user_id	int4	10
comment	user_id	int4	10
organization_user	user_id	int4	10
project_favourite	user_id	int4	10
project_task	user_id	int4	10
project_user	user_id	int4	10
translation_value	user_id	int4	10	√		null
user_language	user_id	int4	10
activity	id	serial	10		√	nextval('lilo_activity_id_seq'::regclass)
address	id	serial	10		√	nextval('lilo_address_id_seq'::regclass)
comment	id	serial	10		√	nextval('lilo_comment_id_seq'::regclass)
invitation	id	serial	10		√	nextval('lilo_invitation_id_seq'::regclass)
organization	id	serial	10		√	nextval('lilo_organization_id_seq'::regclass)
progress	id	serial	10		√	nextval('lilo_progress_id_seq'::regclass)
project	id	serial	10		√	nextval('lilo_project_id_seq'::regclass)
translation_field	id	serial	10		√	nextval('lilo_translation_field_id_seq'::regclass)
translation_group	id	serial	10		√	nextval('lilo_translation_group_id_seq'::regclass)
translation_value	id	serial	10		√	nextval('lilo_translation_value_id_seq'::regclass)
user	id	serial	10		√	nextval('lilo_user_id_seq'::regclass)
project	description	text	2147483647	√		null
invitation	languages	text	2147483647	√		null
activity	meta	text	2147483647	√		null
comment	text	text	2147483647
translation_value	value	text	2147483647
invitation	creationdate	timestamp	29,6
translation_value	creationdate	timestamp	29,6
activity	date	timestamp	29,6
comment	date	timestamp	29,6
address	country	varchar	2	√		null
project	default_language_id	varchar	6	√		null
language	id	varchar	6
comment	language_id	varchar	6	√		null
progress	language_id	varchar	6	√		null
project_language	language_id	varchar	6
project_task	language_id	varchar	6
translation_value	language_id	varchar	6
user_language	language_id	varchar	6
user	username	varchar	30	√		null
address	city	varchar	45	√		null
organization	identifier	varchar	45
project	identifier	varchar	45
address	zipcode	varchar	45	√		null
address	address	varchar	255	√		null
address	company	varchar	255	√		null
invitation	email	varchar	255
organization	email	varchar	255
user	email	varchar	255
address	fax	varchar	255	√		null
address	firstname	varchar	255	√		null
user	firstname	varchar	255	√		null
address	lastname	varchar	255	√		null
user	lastname	varchar	255	√		null
language	name	varchar	255
organization	name	varchar	255
project	name	varchar	255
translation_field	name	varchar	255
translation_group	name	varchar	255
user	password_hash	varchar	255
address	phone	varchar	255	√		null
address	state	varchar	255	√		null
address	vatid	varchar	255	√		null
address	website	varchar	255	√		null