Skip to main content

resources

NameTypeStorageNullableForeign KeysDefault Value & Notes
PKIDintegerplainResource ID
creatorintegerplainusers.IDCreator user ID (defaults to authenticated user on creation)
creationdatebigintplainDefault: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodifiedbigintplainDefault: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
applicationintegerplainapplications.IDApplication ID (`null`=STANDALONE)
activitysmallintplainDefault: 0Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
nametextmainName
identifiercharacter varying(200)mainUnique resource identifier
mimetypetextmainDefault: 'text/x-zymba'MIME type (RFC 2045)
publicsmallintplainDefault: 0Publicly accessible
binfileintegerplainbinfiles.IDNo description provided.
NameUniqueNulls DistinctPrimaryPartialMethodKeys
fk_resources_applicationginapplication
fk_resources_binfilebtreebinfile
pk_resourcesbtreeID
s_resources_identifierginidentifier
s_resources_nameginname
u_resources_identifierbtreeidentifier
NameType
dc_resources_activitycheck
dc_resources_identifiercheck
dc_resources_mimetypecheck
dc_resources_namecheck
fk_resources_applicationforeign_key
fk_resources_binfileforeign_key
fk_resources_creatorforeign_key
pk_resourcesprimary_key
u_resources_identifierunique
Loading...