table service_type
column service_type id serial primary key
column service_type type text not null unique
column service_type description text

data service_type {type: "group"} {}
data service_type {type: "publ"} {}
data service_type {type: "rolle"} {}

table service
column service id serial primary key
column service type text
column service feature text
column service description text
column service hidden boolean

data service {type: "login", feature: "unix"} {description: "Can login on Unix systems", hidden: False} >> data_service_login_unix
data service {type: "login", feature: "wds"} {description: "Can login into WDS", hidden: False} >> data_service_login_wds
data service {type: "login", feature: "wwa"} {description: "Can login into WWA", hidden: False} >> data_service_login_wwa
data service {type: "group", feature: "wifo"} {hidden: False} >> data_service_group_wifo
data service {type: "group", feature: "wifo-intern"} {hidden: False} >> data_service_group_wifo_intern
data service {type: "group", feature: "wsr"} {hidden: False} >> data_service_group_wsr
data service {type: "mailinglist2", feature: "wifo-aktuell"} {hidden: False} >> data_service_mailinglist2_wifo_aktuell
data service {type: "org", feature: "WIFO"} {hidden: False} >> data_service_org_WIFO
data service {type: "org", feature: "WSR"} {hidden: False} >> data_service_org_WSR
data service {type: "publ", feature: "wifo_intern"} {hidden: False} >> data_service_publ_wifo_intern
data service {type: "publ", feature: "wifo_temporary"} {hidden: False} >> data_service_publ_wifo_temporary
data service {type: "rolle", feature: "administrative_staff_member"} {hidden: False} >> data_service_rolle_administrative_staff_member
data service {type: "rolle", feature: "associate"} {hidden: False} >> data_service_rolle_associate
data service {type: "rolle", feature: "economist"} {hidden: False} >> data_service_rolle_economist
data service {type: "rolle", feature: "emeritus_consultant"} {hidden: False} >> data_service_rolle_emeritus_consultant
data service {type: "rolle", feature: "research_assistant"} {hidden: False} >> data_service_rolle_research_assistant
data service {type: "rolle", feature: "scientific_administration_staff_member"} {hidden: False} >> data_service_rolle_scientific_administration_staff_member
data service {type: "rolle", feature: "scientific_administrative_assistant"} {hidden: False} >> data_service_rolle_scientific_administrative_assistant
data service {type: "rolle", feature: "scientific_consultant"} {hidden: False} >> data_service_rolle_scientific_consultant
data service {type: "rolle", feature: "senior_economist"} {hidden: False} >> data_service_rolle_senior_economist

table template
column template id            serial primary key
column template name          text   not null unique
column template sortorder     int
column template email_pattern text
column template email_after   text
column template funktion      text
column template status        text

data template {name: "Standard Vorlage"} {sortorder: 1} >> data_template_std
data template {name: "WIFO Wissenschaftliche Assistenz"} {sortorder: 10, "email_pattern": "vorname#.#nachname", "email_after": "wifo.ac.at", funktion: "FB (1-5)", status: "FU, FM"} >> data_template_wifo_wa

table template_service
column template_service id serial primary key
column template_service template int references template
column template_service service int references service

data template_service {template: @data_template_std/0/id, service: @data_service_login_wwa/0/id} {}