groups


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"groups_ID_seq"'::regclass)
accounts.ownergroup FK_accounts_ownergroup C
actionsteps.ownergroup FK_actionsteps_ownergroup C
appointments.ownergroup FK_appointments_ownergroup C
campaigns.ownergroup FK_campaigns_ownergroup C
categories.ownergroup FK_categories_ownergroup C
contacts.ownergroup FK_contacts_ownergroup C
contracts.ownergroup FK_contracts_ownergroup C
coupons.ownergroup FK_coupons_ownergroup C
davservers.ownergroup FK_davservers_ownergroup C
davservers.recipientgroup FK_davservers_recipientgroup N
dunning.ownergroup FK_dunning_ownergroup C
events.ownergroup FK_events_ownergroup C
feedservers.ownergroup FK_feedservers_ownergroup C
feedservers.recipientgroup FK_feedservers_recipientgroup N
groups2users.group FK_groups2users_group C
items.ownergroup FK_items_ownergroup C
ledgers.ownergroup FK_ledgers_ownergroup C
links.ownergroup FK_links_ownergroup C
mailinglists.ownergroup FK_mailinglists_ownergroup C
mailservers.ownergroup FK_mailservers_ownergroup C
mailservers.recipientgroup FK_mailservers_recipientgroup N
messages.ownergroup FK_messages_ownergroup C
notes.ownergroup FK_notes_ownergroup C
objects.ownergroup FK_objects_ownergroup C
opportunities.ownergroup FK_opportunities_ownergroup C
payments.ownergroup FK_payments_ownergroup C
permissions.group FK_permissions_group C
pricelists.ownergroup FK_pricelists_ownergroup C
projects.ownergroup FK_projects_ownergroup C
records.ownergroup FK_records_ownergroup C
storages.ownergroup FK_storages_ownergroup C
tasks.ownergroup FK_tasks_ownergroup C
tickets.ownergroup FK_tickets_ownergroup C
transactions.ownergroup FK_transactions_ownergroup C
creator int4 10 null
users.ID FK_groups_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

leader int4 10 null
users.ID FK_groups_leader N
activity int2 5 0

0: Active, 1: Deactivated

name text 2147483647 null
description text 2147483647 ''::text

The general description field

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_groups_ID Primary key Asc ID
UNQ_groups_name Must be unique

Relationships