| | | | |
|---|
| Table : Depot (alias : b) |
| | id | INTEGER | | PK |
| | name | TEXT | not null | |
| | code | TEXT | | |
| | description | TEXT | | |
| | icon | TEXT | | |
| | url | TEXT | | |
| | adress_1 | TEXT | | |
| | adress_2 | TEXT | | |
| | city | TEXT | | |
| | zip | TEXT | | |
| | country | TEXT | | |
| Table : Document (alias : d) |
| | id | INTEGER | | PK |
| | name | TEXT | not null | |
| | description | TEXT | | |
| | private | BOOLEAN | | |
| | icon | TEXT | | |
| | url | TEXT | | |
| | cote | TEXT | | |
| | notesearch | TEXT | | |
| | datecreated | DATETIME | | |
| | depot_id | INTEGER | not null | => Depot.id |
| | documenttype_id | INTEGER | not null | => Documenttype.id |
| Table : Documenttype (alias : c) |
| | id | INTEGER | | PK |
| | name | TEXT | not null | |
| | code | TEXT | | |
| | description | TEXT | | |
| | icon | TEXT | | |
| Table : Event (alias : i) |
| | id | INTEGER | | PK |
| | name | TEXT | not null | |
| | description | TEXT | | |
| | private | BOOLEAN | | |
| | date_begin | DATETIME | | |
| | date_begin_accurate | TEXT | | |
| | notesearch | TEXT | | |
| | datecreated | DATETIME | | |
| | person_1_id | INTEGER | not null | => Person.id |
| | person_2_id | INTEGER | | => Person.id |
| | person_3_id | INTEGER | | => Person.id |
| | eventtype_id | INTEGER | not null | => Eventtype.id |
| | place_id | INTEGER | | => Place.id |
| Table : Event_source (alias : k) |
| | id | INTEGER | | PK |
| | event_id | INTEGER | not null | => Event.id |
| | source_id | INTEGER | not null | => Source.id |
| | document_id | INTEGER | | => Document.id |
| | datecreated | DATETIME | | |
| Table : Eventtype (alias : e) |
| | id | INTEGER | | PK |
| | name | TEXT | not null | |
| | code | TEXT | | |
| | category | TEXT | not null | |
| | description | TEXT | | |
| Table : Metadata (alias : f) |
| | id | INTEGER | | PK |
| | name | TEXT | not null | |
| | code | TEXT | | |
| | value | TEXT | not null | |
| | type | TEXT | | |
| | description | TEXT | | |
| Table : Person (alias : g) |
| | id | INTEGER | | PK |
| | displayname | TEXT | not null | |
| | description | TEXT | | |
| | firstname | TEXT | | |
| | lastname | TEXT | | |
| | private | BOOLEAN | | |
| | icon | TEXT | | |
| | sex | TEXT | | |
| | notesearch | TEXT | | |
| | firstnameprefix | TEXT | | |
| | displaynameprefix | TEXT | | |
| | lastnamesuffix | TEXT | | |
| | surname | TEXT | | |
| | datecreated | DATETIME | | |
| Table : Place (alias : h) |
| | id | INTEGER | | PK |
| | name | TEXT | not null | |
| | description | TEXT | | |
| | private | BOOLEAN | | |
| | icon | TEXT | | |
| | adress1 | TEXT | | |
| | adress2 | TEXT | | |
| | zipcode | TEXT | | |
| | city | TEXT | | |
| | cityinsee | INTEGER | | |
| | country | TEXT | | |
| | url | TEXT | | |
| | gpslat | DECIMAL(16, 16) | | |
| | gpslon | DECIMAL(16, 16) | | |
| | datecreated | DATETIME | | |
| Table : Source (alias : j) |
| | id | INTEGER | | PK |
| | name | TEXT | not null | |
| | description | TEXT | | |
| | private | BOOLEAN | | |
| | category | TEXT | not null | |
| | icon | TEXT | | |
| | sourcetext | TEXT | | |
| | sourceurl | TEXT | | |
| | quality | INTEGER | | |
| | page | TEXT | | |
| | citation | TEXT | | |
| | textdraduction | TEXT | | |
| | notesearch | TEXT | | |
| | datecreated | DATETIME | | |
