Liste der Relationen
 Schema |           Name           |  Typ  | Eigentümer 
--------+--------------------------+-------+------------
 public | birthdays                | Sicht | hagen
 public | friends_by_concentration | Sicht | hagen
 public | group_rel_ext            | Sicht | hagen
 public | group_rel_strength       | Sicht | hagen
 public | group_relations          | Sicht | hagen
 public | groups_per_user          | Sicht | hagen
 public | sex_by_concentration     | Sicht | hagen
 public | sex_by_course            | Sicht | hagen
 public | sex_by_uni               | Sicht | hagen
 public | users_per_concentration  | Sicht | hagen
 public | users_per_group          | Sicht | hagen
 public | users_per_uni            | Sicht | hagen
(12 Zeilen)

studivz=> \d birthdays
       Sicht »public.birthdays«
 Spalte |       Typ        | Attribute 
--------+------------------+-----------
 month  | double precision | 
 day    | double precision | 
Sichtdefinition:
 SELECT DISTINCT date_part('month'::text, ud.birthdate) AS "month", date_part('day'::text, ud.birthdate) AS "day"
   FROM user_data ud
  ORDER BY date_part('month'::text, ud.birthdate), date_part('day'::text, ud.birthdate);

studivz=> \d friends_by_concentration 
Sicht »public.friends_by_concentration«
      Spalte      |   Typ   | Attribute 
------------------+---------+-----------
 concentration_id | integer | 
 ext              | numeric | 
 uni              | numeric | 
 all              | numeric | 
Sichtdefinition:
 SELECT cm.concentration_id, avg(ud.ext_friends) AS ext, avg(ud.uni_friends) AS uni, avg(ud.ext_friends + ud.uni_friends) AS "all"
   FROM concentration_members cm, user_data ud
  WHERE cm.user_id = ud.id
  GROUP BY cm.concentration_id;

studivz=> \d group_relations 
Sicht »public.group_relations«
 Spalte |   Typ   | Attribute 
--------+---------+-----------
 gid1   | integer | 
 gid2   | integer | 
 count  | bigint  | 
Sichtdefinition:
 SELECT g1.group_id AS gid1, g2.group_id AS gid2, count(*) AS count
   FROM group_members g1, group_members g2
  WHERE g1.user_id = g2.user_id AND g1.group_id < g2.group_id
  GROUP BY g1.group_id, g2.group_id;

studivz=> \d group_rel_ext 
 Sicht »public.group_rel_ext«
 Spalte |   Typ   | Attribute 
--------+---------+-----------
 gid1   | integer | 
 gid2   | integer | 
 count  | bigint  | 
 users1 | bigint  | 
 users2 | bigint  | 
Sichtdefinition:
 SELECT rel.gid1, rel.gid2, rel.count, u1.count AS users1, u2.count AS users2
   FROM group_relations rel, users_per_group u1, users_per_group u2
  WHERE rel.gid1 = u1.group_id AND rel.gid2 = u2.group_id;

studivz=> \d group_rel_strength 
  Sicht »public.group_rel_strength«
     Spalte     |   Typ   | Attribute 
----------------+---------+-----------
 left_strength  | numeric | 
 right_strength | numeric | 
 strength       | numeric | 
 gid1           | integer | 
 gid2           | integer | 
 count          | bigint  | 
 users1         | bigint  | 
 users2         | bigint  | 
Sichtdefinition:
 SELECT 1.0 * group_rel_ext.count::numeric / group_rel_ext.users1::numeric AS left_strength, 1.0 * group_rel_ext.count::numeric / group_rel_ext.users2::numeric AS right_strength, 1.0 * group_rel_ext.count::numeric / group_rel_ext.users1::numeric + 1.0 * group_rel_ext.count::numeric / group_rel_ext.users2::numeric AS strength, group_rel_ext.gid1, group_rel_ext.gid2, group_rel_ext.count, group_rel_ext.users1, group_rel_ext.users2
   FROM group_rel_ext;

studivz=> \d groups_per_user 
Sicht »public.groups_per_user«
 Spalte  |   Typ   | Attribute 
---------+---------+-----------
 user_id | integer | 
 count   | bigint  | 
Sichtdefinition:
 SELECT group_members.user_id, count(*) AS count
   FROM group_members group_members
  GROUP BY group_members.user_id;

studivz=> \d sex_by_concentration 
   Sicht »public.sex_by_concentration«
      Spalte      |   Typ    | Attribute 
------------------+----------+-----------
 concentration_id | integer  | 
 sex              | smallint | 
 count            | bigint   | 
Sichtdefinition:
 SELECT cm.concentration_id, ud.sex, count(*) AS count
   FROM concentration_members cm, user_data ud
  WHERE cm.user_id = ud.id
  GROUP BY cm.concentration_id, ud.sex;

studivz=> \d sex_by_uni 
   Sicht »public.sex_by_uni«
 Spalte |   Typ    | Attribute 
--------+----------+-----------
 uni_id | integer  | 
 sex    | smallint | 
 count  | bigint   | 
Sichtdefinition:
 SELECT u.uni_id, ud.sex, count(*) AS count
   FROM users u, user_data ud
  WHERE u.id = ud.id
  GROUP BY u.uni_id, ud.sex;

studivz=> \d sex_by_course 
   Sicht »public.sex_by_course«
  Spalte   |   Typ    | Attribute 
-----------+----------+-----------
 course_id | integer  | 
 sex       | smallint | 
 count     | bigint   | 
Sichtdefinition:
 SELECT cm.course_id, ud.sex, count(*) AS count
   FROM course_members cm, user_data ud
  WHERE cm.user_id = ud.id
  GROUP BY cm.course_id, ud.sex;

studivz=> \d users_per_concentration 
 Sicht »public.users_per_concentration«
      Spalte      |   Typ   | Attribute 
------------------+---------+-----------
 concentration_id | integer | 
 count            | bigint  | 
Sichtdefinition:
 SELECT cm.concentration_id, count(*) AS count
   FROM concentration_members cm, users u
  WHERE cm.user_id = u.id
  GROUP BY cm.concentration_id;

studivz=> \d users_per_group 
 Sicht »public.users_per_group«
  Spalte  |   Typ   | Attribute 
----------+---------+-----------
 group_id | integer | 
 count    | bigint  | 
Sichtdefinition:
 SELECT group_members.group_id, count(*) AS count
   FROM group_members group_members
  GROUP BY group_members.group_id;

studivz=> \d users_per_uni
 Sicht »public.users_per_uni«
 Spalte |   Typ   | Attribute 
--------+---------+-----------
 uni_id | integer | 
 count  | bigint  | 
Sichtdefinition:
 SELECT u.uni_id, count(*) AS count
   FROM users u
  GROUP BY u.uni_id;