vw.md

vouliwatch.gr

components

search

item feed

news feed

votes feed

live streaming

radio

objects

documenttype

{
	id string 60 pk
	title string 255
}

documentstatus

{
	id string 60 pk
	title string 255
}

documentcategory

{
	id int inc pk
	title
	description
}

documentcategorytree

{ document_id child_id }

documenttags

tag

{
	id int inc pk
	slug string 100 unq
	name string 255
	alias?
}

documents

{
	id uuid
	document_type string 60 fk documenttype
	title string 255 ft
	slug string 255 index
	subtitle string 255 ft
	abstract text ft
	status string 60
	body text ft
	lang string 10 index
	created_at datetime
	updated_at datetime
	created_by string 100 fk user_id on update cascade
	updated_by string 100 fk user_id on update cascade
}

acl?

acl module

users

{
	user_id string 100 pk
}

userprofile

roles

userroles

groups

usergroups

grouproles

comments

{
	id bigint inc pk
	document_id
	user_id string 100 fk user on udpate cascade
	body
	created_at datetime
	updated_at datetime
	status string 60 fk comment_status
}

commentstatus

{
	status string 60 pk
}

commenttree

{
	comment_id bigint  pk fk comments
	child_id bigint pk fk comments
}

documentlike

{
	user_id
	document_id
	updted_at 
	vote -1 0 1 default 0
}

news article

person

personpositions

organisation

politicalparty

parliamentgroup

parliament

position

votes

votearticle

personvotestatus

{
	id string 60
	title string 60
}

personvote

{
	person_id
	document_id
	vote -1 0 1
}

questions

answers

media

{
	type
	mimetype
	url
	source
	copyright
	title
	description
	body
}

news article

{
	editors user[]
	title
	subtitle
	abstract
	searchtext
	body
}

userpoll

{

}

vote

{
	articles votearticle[]
	votedate date
	votes vote[]
	yay
	nay
	bah       
}

votearticle

{
	positions partyposition[]
	votes vote[]
	yay
	nay
	bah       
}

votevote

{
	articleid
	pmid
	vote
}

partyposition

{
	relatesto document
}

user

pm

{
	user
}

radio show

region

question

question thread

answers of questioneee(?)

question discussion

comment

position