git.roojs.org Git - xtuple/blob - enyo-client/database/orm/models/sys.json

   1 [
   2   {
   3     "context": "xtuple",
   4     "nameSpace": "SYS",
   5     "type": "User",
   6     "table": "xt.usrinfo",
   7     "comment": "User Map",
   8     "privileges": {
   9       "all": {
  10         "create": "MaintainUsers",
  11         "read": "MaintainUsers",
  12         "update": "MaintainUsers",
  13         "delete": false
  14       }
  15     },
  16     "properties": [
  17       {
  18         "name": "username",
  19         "attr": {
  20           "type": "String",
  21           "column": "usr_username",
  22           "isPrimaryKey": true,
  23           "isNaturalKey": true
  24         }
  25       },
  26       {
  27         "name": "properName",
  28         "attr": {
  29           "type": "String",
  30           "column": "usr_propername"
  31         }
  32       },
  33       {
  34         "name": "useEnhancedAuth",
  35         "attr": {
  36           "type": "Boolean",
  37           "column": "usr_enhancedauth"
  38         }
  39       },
  40       {
  41         "name": "disableExport",
  42         "attr": {
  43           "type": "Boolean",
  44           "column": "usr_disable_export"
  45         }
  46       },
  47       {
  48         "name": "isActive",
  49         "attr": {
  50           "type": "Boolean",
  51           "column": "usr_active"
  52         }
  53       },
  54       {
  55         "name": "initials",
  56         "attr": {
  57           "type": "String",
  58           "column": "usr_initials"
  59         }
  60       },
  61       {
  62         "name": "email",
  63         "attr": {
  64           "type": "String",
  65           "column": "usr_email"
  66         }
  67       },
  68       {
  69         "name": "organization",
  70         "attr": {
  71           "type": "String",
  72           "column": "usr_org"
  73         }
  74       },
  75       {
  76         "name": "grantedUserAccountRoles",
  77         "toMany": {
  78           "column": "usr_username",
  79           "type": "UserAccountUserAccountRoleAssignment",
  80           "inverse": "userAccount",
  81           "isNested": true
  82         }
  83       },
  84       {
  85         "name": "grantedPrivileges",
  86         "toMany": {
  87           "column": "usr_username",
  88           "type": "UserAccountPrivilegeAssignment",
  89           "inverse": "userAccount",
  90           "isNested": true
  91         }
  92       },
  93       {
  94         "name": "grantedExtensions",
  95         "toMany": {
  96           "column": "usr_username",
  97           "type": "UserExtension",
  98           "inverse": "user",
  99           "isNested": true
 100         }
 101       }
 102     ],
 103     "isSystem": true,
 104     "sourceCode": "U"
 105   },
 106   {
 107     "context": "xtuple",
 108     "nameSpace": "SYS",
 109     "type": "UserAccountPrivilegeAssignment",
 110     "table": "usrpriv",
 111     "idSequenceName": "usrpriv_usrpriv_id_seq",
 112     "comment": "User Account Privilege Assignment Map",
 113     "privileges": {
 114       "all": {
 115         "create": true,
 116         "read": true,
 117         "update": false,
 118         "delete": true
 119       }
 120     },
 121     "properties": [
 122       {
 123         "name": "id",
 124         "attr": {
 125           "type": "Number",
 126           "column": "usrpriv_id",
 127           "isPrimaryKey": true
 128         }
 129       },
 130       {
 131         "name": "uuid",
 132         "attr": {
 133           "type": "String",
 134           "column": "obj_uuid",
 135           "isNaturalKey": true
 136         }
 137       },
 138       {
 139         "name": "userAccount",
 140         "attr": {
 141           "type": "String",
 142           "column": "usrpriv_username",
 143           "required": true
 144         }
 145       },
 146       {
 147         "name": "privilege",
 148         "toOne": {
 149           "type": "Privilege",
 150           "column": "usrpriv_priv_id",
 151           "required": true
 152         }
 153       }
 154     ],
 155     "isNestedOnly": true,
 156     "isSystem": true
 157   },
 158   {
 159     "context": "xtuple",
 160     "nameSpace": "SYS",
 161     "type": "Privilege",
 162     "table": "priv",
 163     "comment": "Privilege Map",
 164     "privileges": {
 165       "all": {
 166         "create": false,
 167         "read": true,
 168         "update": false,
 169         "delete": false
 170       }
 171     },
 172     "properties": [
 173       {
 174         "name": "id",
 175         "attr": {
 176           "type": "Number",
 177           "column": "priv_id",
 178           "isPrimaryKey": true
 179         }
 180       },
 181       {
 182         "name": "name",
 183         "attr": {
 184           "type": "String",
 185           "column": "priv_name",
 186           "isNaturalKey": true
 187         }
 188       },
 189       {
 190         "name": "module",
 191         "attr": {
 192           "type": "String",
 193           "column": "priv_module"
 194         }
 195       }
 196     ],
 197     "isSystem": true
 198   },
 199   {
 200     "context": "xtuple",
 201     "nameSpace": "SYS",
 202     "type": "UserAccountRole",
 203     "table": "grp",
 204     "idSequenceName": "grp_grp_id_seq",
 205     "comment": "User Account Role Map",
 206     "privileges": {
 207       "all": {
 208         "create": "MaintainGroups",
 209         "read": "MaintainGroups",
 210         "update": "MaintainGroups",
 211         "delete": "MaintainGroups"
 212       }
 213     },
 214     "properties": [
 215       {
 216         "name": "id",
 217         "attr": {
 218           "type": "Number",
 219           "column": "grp_id",
 220           "isPrimaryKey": true
 221         }
 222       },
 223       {
 224         "name": "name",
 225         "attr": {
 226           "type": "String",
 227           "column": "grp_name",
 228           "isNaturalKey":true
 229         }
 230       },
 231       {
 232         "name": "description",
 233         "attr": {
 234           "type": "String",
 235           "column": "grp_descrip"
 236         }
 237       },
 238       {
 239         "name": "grantedExtensions",
 240         "toMany": {
 241           "column": "grp_id",
 242           "type": "UserAccountRoleExtension",
 243           "inverse": "userAccountRole",
 244           "isNested": true
 245         }
 246       }
 247     ],
 248     "isSystem": true
 249   },
 250   {
 251     "context": "xtuple",
 252     "nameSpace": "SYS",
 253     "type": "UserAccountUserAccountRoleAssignment",
 254     "table": "usrgrp",
 255     "idSequenceName": "usrgrp_usrgrp_id_seq",
 256     "comment": "User User Role Assignment Map",
 257     "privileges": {
 258       "all": {
 259         "create": true,
 260         "read": true,
 261         "update": false,
 262         "delete": true
 263       }
 264     },
 265     "properties": [
 266       {
 267         "name": "id",
 268         "attr": {
 269           "type": "Number",
 270           "column": "usrgrp_id",
 271           "isPrimaryKey": true
 272         }
 273       },
 274       {
 275         "name": "uuid",
 276         "attr": {
 277           "type": "String",
 278           "column": "obj_uuid",
 279           "isNaturalKey": true
 280         }
 281       },
 282       {
 283         "name": "userAccount",
 284         "attr": {
 285           "type": "String",
 286           "column": "usrgrp_username"
 287         }
 288       },
 289       {
 290         "name": "userAccountRole",
 291         "toOne": {
 292           "type": "UserAccountRole",
 293           "column": "usrgrp_grp_id"
 294         }
 295       }
 296     ],
 297     "isNestedOnly": true,
 298     "isSystem": true
 299   },
 300   {
 301     "context": "xtuple",
 302     "nameSpace": "SYS",
 303     "type": "ClientCode",
 304     "table": "xt.clientcode",
 305     "idSequenceName": "clientcode_clientcode_id_seq",
 306     "comment": "Client Code (with the code) Assignment Map",
 307     "privileges": {
 308       "all": {
 309         "create": false,
 310         "read": true,
 311         "update": false,
 312         "delete": false
 313       }
 314     },
 315     "properties": [
 316       {
 317         "name": "id",
 318         "attr": {
 319           "type": "Number",
 320           "column": "clientcode_id",
 321           "isPrimaryKey": true
 322         }
 323       },
 324       {
 325         "name": "uuid",
 326         "attr": {
 327           "type": "String",
 328           "column": "obj_uuid",
 329           "isNaturalKey": true
 330         }
 331       },
 332       {
 333         "name": "code",
 334         "attr": {
 335           "type": "String",
 336           "column": "clientcode_code"
 337         }
 338       },
 339       {
 340         "name": "extension",
 341         "attr": {
 342           "type": "Number",
 343           "column": "clientcode_ext_id"
 344         }
 345       },
 346       {
 347         "name": "version",
 348         "attr": {
 349           "type": "String",
 350           "column": "clientcode_version"
 351         }
 352       },
 353       {
 354         "name": "language",
 355         "attr": {
 356           "type": "String",
 357           "column": "clientcode_language"
 358         }
 359       }
 360     ],
 361     "isSystem": true
 362   },
 363   {
 364     "context": "xtuple",
 365     "nameSpace": "SYS",
 366     "type": "ClientCodeRelation",
 367     "table": "xt.clientcode",
 368     "idSequenceName": "clientcode_clientcode_id_seq",
 369     "comment": "Client Code Information (w/o the code) Assignment Map",
 370     "privileges": {
 371       "all": {
 372         "create": false,
 373         "read": true,
 374         "update": false,
 375         "delete": false
 376       }
 377     },
 378     "properties": [
 379       {
 380         "name": "id",
 381         "attr": {
 382           "type": "Number",
 383           "column": "clientcode_id",
 384           "isPrimaryKey": true
 385         }
 386       },
 387       {
 388         "name": "uuid",
 389         "attr": {
 390           "type": "String",
 391           "column": "obj_uuid",
 392           "isNaturalKey": true
 393         }
 394       },
 395       {
 396         "name": "extension",
 397         "attr": {
 398           "type": "Number",
 399           "column": "clientcode_ext_id"
 400         }
 401       },
 402       {
 403         "name": "version",
 404         "attr": {
 405           "type": "String",
 406           "column": "clientcode_version"
 407         }
 408       },
 409       {
 410         "name": "language",
 411         "attr": {
 412           "type": "String",
 413           "column": "clientcode_language"
 414         }
 415       }
 416     ],
 417     "isSystem": true
 418   },
 419   {
 420     "context": "xtuple",
 421     "nameSpace": "SYS",
 422     "type": "Recover",
 423     "table": "xt.recover",
 424     "idSequenceName": "recover_recover_id_seq",
 425     "comment": "Password Recovery Table Map",
 426     "privileges": {
 427       "all": {
 428         "create": "MaintainUsers",
 429         "read": "MaintainUsers",
 430         "update": "MaintainUsers",
 431         "delete": "MaintainUsers"
 432       }
 433     },
 434     "properties": [
 435       {
 436         "name": "id",
 437         "attr": {
 438           "type": "Number",
 439           "column": "recover_id",
 440           "isPrimaryKey": true
 441         }
 442       },
 443       {
 444         "name": "recoverUsername",
 445         "attr": {
 446           "type": "String",
 447           "column": "recover_username"
 448         }
 449       },
 450       {
 451         "name": "hashedToken",
 452         "attr": {
 453           "type": "String",
 454           "column": "recover_hashed_token"
 455         }
 456       },
 457       {
 458         "name": "createdTimestamp",
 459         "attr": {
 460           "type": "Date",
 461           "column": "recover_created_timestamp"
 462         }
 463       },
 464       {
 465         "name": "accessed",
 466         "attr": {
 467           "type": "Boolean",
 468           "column": "recover_accessed"
 469         }
 470       },
 471       {
 472         "name": "accessedTimestamp",
 473         "attr": {
 474           "type": "Date",
 475           "column": "recover_accessed_timestamp"
 476         }
 477       },
 478       {
 479         "name": "reset",
 480         "attr": {
 481           "type": "Boolean",
 482           "column": "recover_reset"
 483         }
 484       },
 485       {
 486         "name": "resetTimestamp",
 487         "attr": {
 488           "type": "Date",
 489           "column": "recover_reset_timestamp"
 490         }
 491       },
 492       {
 493         "name": "expiresTimestamp",
 494         "attr": {
 495           "type": "Date",
 496           "column": "recover_expires_timestamp"
 497         }
 498       },
 499       {
 500         "name": "ip",
 501         "attr": {
 502           "type": "String",
 503           "column": "recover_ip"
 504         }
 505       }
 506     ],
 507     "isSystem": true
 508   },
 509   {
 510     "context": "xtuple",
 511     "nameSpace": "SYS",
 512     "type": "ReportDefinition",
 513     "table": "xt.rptdef",
 514     "idSequenceName": "rptdef_rptdef_id_seq",
 515     "comment": "Report Definition Table Map",
 516     "privileges": {
 517       "all": {
 518         "create": false,
 519         "read": true,
 520         "update": false,
 521         "delete": false
 522       }
 523     },
 524     "properties": [
 525       {
 526         "name": "id",
 527         "attr": {
 528           "type": "Number",
 529           "column": "rptdef_id",
 530           "isPrimaryKey": true
 531         }
 532       },
 533       {
 534         "name": "recordType",
 535         "attr": {
 536           "type": "String",
 537           "column": "rptdef_record_type"
 538         }
 539       },
 540       {
 541         "name": "grade",
 542         "attr": {
 543           "type": "Number",
 544           "column": "rptdef_grade"
 545         }
 546       },
 547       {
 548         "name": "definition",
 549         "attr": {
 550           "type": "String",
 551           "column": "rptdef_definition"
 552         }
 553       }
 554     ],
 555     "isSystem": true
 556   }
 557 ]