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

   1 [
   2   {
   3     "context": "xtuple",
   4     "nameSpace": "XM",
   5     "type": "Site",
   6     "table": "xt.site",
   7     "idSequenceName": "warehous_warehous_id_seq",
   8     "isRest": true,
   9     "lockable": true,
  10     "lockTable": "whsinfo",
  11     "comment": "Site Map",
  12     "privileges": {
  13       "all": {
  14         "create": "MaintainWarehouses",
  15         "read": "ViewWarehouses",
  16         "update": "MaintainWarehouses",
  17         "delete": "MaintainWarehouses"
  18       }
  19     },
  20     "properties": [
  21       {
  22         "name": "id",
  23         "attr": {
  24           "type": "Number",
  25           "column": "warehous_id",
  26           "isPrimaryKey": true
  27         }
  28       },
  29       {
  30         "name": "code",
  31         "attr": {
  32           "type": "String",
  33           "column": "warehous_code",
  34           "isNaturalKey":true
  35         }
  36       },
  37       {
  38         "name": "siteType",
  39         "toOne": {
  40           "isNested": true,
  41           "type": "SiteType",
  42           "column": "warehous_sitetype_id"
  43         }
  44       },
  45       {
  46         "name": "isActive",
  47         "attr": {
  48           "type": "Boolean",
  49           "column": "warehous_active"
  50         }
  51       },
  52       {
  53         "name": "description",
  54         "attr": {
  55           "type": "String",
  56           "column": "warehous_descrip"
  57         }
  58       },
  59       {
  60         "name": "contact",
  61         "toOne": {
  62           "isNested": true,
  63           "type": "ContactRelation",
  64           "column": "warehous_cntct_id"
  65         }
  66       },
  67       {
  68         "name": "address",
  69         "toOne": {
  70           "isNested": true,
  71           "type": "AddressInfo",
  72           "column": "warehous_addr_id"
  73         }
  74       },
  75       {
  76         "name": "taxZone",
  77         "toOne": {
  78           "type": "TaxZone",
  79           "column": "warehous_taxzone_id"
  80         }
  81       },
  82       {
  83         "name": "incoterms",
  84         "attr": {
  85           "type": "String",
  86           "column": "warehous_fob"
  87         }
  88       },
  89       {
  90         "name": "notes",
  91         "attr": {
  92           "type": "String",
  93           "column": "warehous_shipcomments"
  94         }
  95       },
  96       {
  97         "name": "comments",
  98         "toMany": {
  99           "isNested": true,
 100           "type": "SiteComment",
 101           "column": "warehous_id",
 102           "inverse": "site"
 103         }
 104       }
 105     ],
 106     "isSystem": true
 107   },
 108   {
 109     "context": "xtuple",
 110     "nameSpace": "XM",
 111     "type": "SiteComment",
 112     "table": "comment",
 113     "idSequenceName": "comment_comment_id_seq",
 114     "comment": "Site Comment Map",
 115     "privileges": {
 116       "all": {
 117         "create": true,
 118         "read": true,
 119         "update": "EditOthersComments",
 120         "delete": false
 121       },
 122       "personal": {
 123         "update": "EditOwnComments",
 124         "properties": [
 125           "createdBy"
 126         ]
 127       }
 128     },
 129     "properties": [
 130       {
 131         "name": "id",
 132         "attr": {
 133           "type": "Number",
 134           "column": "comment_id",
 135           "isPrimaryKey": true
 136         }
 137       },
 138       {
 139         "name": "uuid",
 140         "attr": {
 141           "type": "String",
 142           "column": "obj_uuid",
 143           "isNaturalKey": true
 144         }
 145       },
 146       {
 147         "name": "sourceType",
 148         "attr": {
 149           "type": "String",
 150           "column": "comment_source",
 151           "value": "WH"
 152         }
 153       },
 154       {
 155         "name": "site",
 156         "attr": {
 157           "type": "Number",
 158           "column": "comment_source_id"
 159         }
 160       },
 161       {
 162         "name": "commentType",
 163         "toOne": {
 164           "type": "CommentType",
 165           "column": "comment_cmnttype_id",
 166           "required": true
 167         }
 168       },
 169       {
 170         "name": "text",
 171         "attr": {
 172           "type": "String",
 173           "column": "comment_text"
 174         }
 175       },
 176       {
 177         "name": "isPublic",
 178         "attr": {
 179           "type": "Boolean",
 180           "column": "comment_public",
 181           "value": true
 182         }
 183       },
 184       {
 185         "name": "created",
 186         "attr": {
 187           "type": "Date",
 188           "column": "comment_date"
 189         }
 190       },
 191       {
 192         "name": "createdBy",
 193         "attr": {
 194           "type": "String",
 195           "column": "comment_user"
 196         }
 197       }
 198     ],
 199     "isNestedOnly": true,
 200     "isSystem": true
 201   },
 202   {
 203     "context": "xtuple",
 204     "nameSpace": "XM",
 205     "type": "SiteZoneRelation",
 206     "table": "whsezone",
 207     "isRest": true,
 208     "comment": "Site Zone List Map",
 209     "privileges": {
 210       "all": {
 211         "create": false,
 212         "read": true,
 213         "update": false,
 214         "delete": false
 215       }
 216     },
 217     "properties": [
 218       {
 219         "name": "id",
 220         "attr": {
 221           "type": "Number",
 222           "column": "whsezone_id",
 223           "isPrimaryKey": true
 224         }
 225       },
 226       {
 227         "name": "site",
 228         "toOne": {
 229           "type": "SiteRelation",
 230           "column": "whsezone_warehous_id"
 231         }
 232       },
 233       {
 234         "name": "name",
 235         "attr": {
 236           "type": "String",
 237           "column": "whsezone_name",
 238           "isNaturalKey":true
 239         }
 240       },
 241       {
 242         "name": "description",
 243         "attr": {
 244           "type": "String",
 245           "column": "whsezone_descrip"
 246         }
 247       }
 248     ],
 249     "isSystem": true
 250   },
 251   {
 252     "context": "xtuple",
 253     "nameSpace": "XM",
 254     "type": "SiteZone",
 255     "table": "whsezone",
 256     "idSequenceName": "whsezone_whsezone_id_seq",
 257     "lockable": true,
 258     "comment": "Site Zone Map",
 259     "properties": [
 260       {
 261         "name": "id",
 262         "attr": {
 263           "type": "Number",
 264           "column": "whsezone_id",
 265           "isPrimaryKey": true
 266         }
 267       },
 268       {
 269         "name": "site",
 270         "attr": {
 271           "type": "Number",
 272           "column": "whsezone_warehous_id"
 273         }
 274       },
 275       {
 276         "name": "name",
 277         "attr": {
 278           "type": "String",
 279           "column": "whsezone_name",
 280           "isNaturalKey":true
 281         }
 282       },
 283       {
 284         "name": "description",
 285         "attr": {
 286           "type": "String",
 287           "column": "whsezone_descrip"
 288         }
 289       }
 290     ],
 291     "isNestedOnly": true,
 292     "isSystem": true
 293   },
 294   {
 295     "context": "xtuple",
 296     "nameSpace": "XM",
 297     "type": "SiteListItem",
 298     "table": "xt.site",
 299     "isRest": true,
 300     "comment": "Site Info Map",
 301     "privileges": {
 302       "all": {
 303         "create": false,
 304         "read": true,
 305         "update": false,
 306         "delete": false
 307       }
 308     },
 309     "properties": [
 310       {
 311         "name": "id",
 312         "attr": {
 313           "type": "Number",
 314           "column": "warehous_id",
 315           "isPrimaryKey": true
 316         }
 317       },
 318       {
 319         "name": "code",
 320         "attr": {
 321           "type": "String",
 322           "column": "warehous_code",
 323           "isNaturalKey":true
 324         }
 325       },
 326       {
 327         "name": "isActive",
 328         "attr": {
 329           "type": "Boolean",
 330           "column": "warehous_active"
 331         }
 332       },
 333       {
 334         "name": "description",
 335         "attr": {
 336           "type": "String",
 337           "column": "warehous_descrip"
 338         }
 339       },
 340       {
 341         "name": "siteType",
 342         "toOne": {
 343           "type": "SiteType",
 344           "column": "warehous_sitetype_id"
 345         }
 346       }
 347     ],
 348     "isSystem": true
 349   },
 350   {
 351     "context": "xtuple",
 352     "nameSpace": "XM",
 353     "type": "SiteRelation",
 354     "table": "xt.site",
 355     "isRest": true,
 356     "comment": "Site Info Map",
 357     "privileges": {
 358       "all": {
 359         "create": false,
 360         "read": true,
 361         "update": false,
 362         "delete": false
 363       }
 364     },
 365     "properties": [
 366       {
 367         "name": "id",
 368         "attr": {
 369           "type": "Number",
 370           "column": "warehous_id",
 371           "isPrimaryKey": true
 372         }
 373       },
 374       {
 375         "name": "code",
 376         "attr": {
 377           "type": "String",
 378           "column": "warehous_code",
 379           "isNaturalKey":true
 380         }
 381       },
 382       {
 383         "name": "description",
 384         "attr": {
 385           "type": "String",
 386           "column": "warehous_descrip"
 387         }
 388       },
 389       {
 390         "name": "isActive",
 391         "attr": {
 392           "type": "Boolean",
 393           "column": "warehous_active"
 394         }
 395       },
 396       {
 397         "name": "address",
 398         "toOne": {
 399           "isNested": true,
 400           "type": "AddressInfo",
 401           "column": "warehous_addr_id"
 402         }
 403       },
 404       {
 405         "name": "contact",
 406         "toOne": {
 407           "isNested": true,
 408           "type": "ContactRelation",
 409           "column": "warehous_cntct_id"
 410         }
 411       },
 412       {
 413         "name": "taxZone",
 414         "toOne": {
 415           "type": "TaxZone",
 416           "column": "warehous_taxzone_id"
 417         }
 418       },
 419       {
 420         "name": "incoterms",
 421         "attr": {
 422           "type": "String",
 423           "column": "warehous_fob"
 424         }
 425       }
 426     ],
 427     "isSystem": true
 428   },
 429   {
 430     "context": "xtuple",
 431     "nameSpace": "XM",
 432     "type": "SiteType",
 433     "table": "sitetype",
 434     "isRest": true,
 435     "idSequenceName": "sitetype_sitetype_id_seq",
 436     "lockable": true,
 437     "comment": "Site Type Map",
 438     "privileges": {
 439       "all": {
 440         "create": "MaintainSiteTypes",
 441         "read": "ViewSiteTypes",
 442         "update": "MaintainSiteTypes",
 443         "delete": "MaintainSiteTypes"
 444       }
 445     },
 446     "properties": [
 447       {
 448         "name": "id",
 449         "attr": {
 450           "type": "Number",
 451           "column": "sitetype_id",
 452           "isPrimaryKey": true
 453         }
 454       },
 455       {
 456         "name": "name",
 457         "attr": {
 458           "type": "String",
 459           "column": "sitetype_name",
 460           "isNaturalKey":true
 461         }
 462       },
 463       {
 464         "name": "description",
 465         "attr": {
 466           "type": "String",
 467           "column": "sitetype_descrip"
 468         }
 469       }
 470     ],
 471     "isSystem": true
 472   }
 473 ]