revinfo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
accountgroup_aud.REV FKfrkd1w0uhi0xw191ocvykfw96 R
address_aud.REV FK86bl6eqdcit8obn2jl1xoote8 R
asaccount_aud.REV FKmlth3ir9yotyhh6pv0ew1wssr R
assocprice_aud.REV FKguhiw3uyoga3yfsq8uf8njjgm R
bireport_aud.REV FKqpcpk3a5c8ugvdsdo6b06va R
bireportaccess_aud.REV FKqpcpk3a5c8uggbfd7b06va R
biscript_aud.REV FKqpcpk3a5c8ug395etdo6b06va R
bom_aud.REV FKk00jevyha8ruf8x0v5ugeeobp R
bominstructionitem_aud.REV FK1vo0pg9iigivovt1gse06bjv R
bomitem_aud.REV FK8hjablrpk36hlr44c9jj306av R
bomitemgroup_aud.REV FKlgmfoo4xacnhy6urfd6ras0r8 R
bomitemtolocation_aud.REV FKi06441fdbl2a3hfba30e3wd6y R
bomtolocation_aud.REV FKgwehkh5qq4a5qecanbaib0wsa R
calcategory_aud.REV FKoeogoj31jwsrf4r5ienx4ujk1 R
calevent_aud.REV FKrdqlm5pqnm2dnqxtkoodin5qm R
carrier_aud.REV FKjkqq4imwynprvus6o258ffmgx R
carrierservice_aud.REV FKkopeina0821aum49whf1jf6x9 R
cartontype_aud.REV FK1g9a9878mfgwb3586ewxa6pt5 R
company_aud.REV FKq68cruh6ey40a09equdo466u6 R
contact_aud.REV FKobmnfjhgld8vi91gqvqpxqahh R
costlayer_aud.REV FKabu1lhpwohw3bvc5vtni2flms R
countryconst_aud.REV FKb6rhult7lrbon1xgag9w8rkyj R
currency_aud.REV FKmyg2tdk5kbxi3xepnw7cr9td6 R
customer_aud.REV FKid3qexmiqlncrl1jv0y18eweg R
customerparts_aud.REV FK9ub3jtiub9wui9mgf28bfjagw R
customfield_aud.REV FK5vwfrj4l3lsigyp3idqrht7ck R
customlist_aud.REV FK80qirdkgd4p90uphnhyp9e9ut R
customlistitem_aud.REV FKfp0qdc59on2kexiidvkwy19do R
dataexport_aud.REV FK6b2o1gal5aebjrd115iiypofd R
defaultlocation_aud.REV FK6cx70dhpxe9ulk10us4cnwbj9 R
fbschedule_aud.REV FK74r6lkxkr857a0xsk1q1hhja6 R
fobpoint_aud.REV FKpw0g9pp0ch1etlnisgg8jn23b R
integratedapp_aud.REV FKbbtrdca3onysy2kyn5o8iayia R
itemadjust_aud.REV FKqc2bi5ysdtly3lc6p5o70f9ii R
kititem_aud.REV FKgue87tf19wjb4x43w38da343t R
kitoption_aud.REV FKbdmobuo6xq72spfg7784iai46 R
location_aud.REV FKofs9ybjsfgkh8h6jtkugx615w R
locationgroup_aud.REV FK2opw7b30nrf2iv1vde468f8h6 R
memo_aud.REV FKfs1f9qkdywljoe8de5pvh112l R
mo_aud.REV FKp166bbsgmnfsxpdx7crilasqb R
moitem_aud.REV FKffebj2go345hbnk4xbo5b0u7m R
objecttoobject_aud.REV FKg44424j32355gvfbh265qvtuq R
part_aud.REV FKq5ciejt20syacn3fb8qbc38i2 R
partcost_aud.REV FKhubwbu9rsjjdiv88j76vvktcg R
partreorder_aud.REV FKgnn397i9py5cj6e51c2wm22wr R
parttotracking_aud.REV FKoxrhfv2hk5xcam0o7151x0sb2 R
parttracking_aud.REV FKiun52c7xy2ckiu248ju0by7ce R
paymentmethod_aud.REV FK6v39roobtel59u0xxedulxdqi R
paymentterms_aud.REV FKb1favow7864wx8r5obhhfvlgy R
pick_aud.REV FKgrk0c42s6k6bruqg6i92lrlls R
pickitem_aud.REV FKt57jp0r9d68qcyax4tcnccxol R
plugininfo_aud.REV FKb72469tuj9vwgibnfkxh33xjw R
pluginproperties_aud.REV FKlsn9q6u20oy4qqka8snk8waoc R
po_aud.REV FKtcxtnjt3c8qbv560db3dl01i8 R
poitem_aud.REV FK1agmw2fkd9wcnwtp1iklffvq0 R
postransaction_aud.REV FKd1ubqoto2p6ty22p74g38cp2v R
pricingrule_aud.REV FKr13divdm7gjs1c3hw1bgc5wts R
product_aud.REV FKoovhds11g6rc5g75l9dx1utfs R
producttotree_aud.REV FK7mqbb09rekboyauqv5k0ne14d R
producttree_aud.REV FKjyc4xhi63elbhnqlca20a7wc4 R
qbclass_aud.REV FKhck49csgi5egyqhxf875rx4od R
quicklist_aud.REV FK1ryanhaeik2gyghu1w95r7yue R
quicklistitem_aud.REV FK1quxnacmgposrmprnn2qv9odr R
receipt_aud.REV FKc2liwj75wuhhydftax1gmwp4o R
receiptitem_aud.REV FKyxpalvufmsjq7nmsih8vnpcg R
register_aud.REV FKed0fyhw389i8p0ml0linv2p00 R
report_aud.REV FK9jco7b1dh8fntwnvsxgxtoisx R
reportparameter_aud.REV FK1e0t69435c18wj78w8w0lnt02 R
reporttomodule_aud.REV FKtggxeb3tndohaxdjp48nv7oah R
reporttree_aud.REV FKse3vhbaud1ix4h38tl0k6pyth R
rma_aud.REV FK4hvegwnqn6psh16no1sg77pnv R
rmaitem_aud.REV FKm71h1f94jx8hq7j9su5hva9sw R
serial_aud.REV FKo8gynnnwtnp5aw6vfvypgeioy R
serialnum_aud.REV FKfbf48e6ib81j7ntkj2lotlo64 R
ship_aud.REV FKafpde4ksy85kli396p8qr5hab R
shipcarton_aud.REV FKfgcy1niav3yjnjvfspk73wopt R
shipitem_aud.REV FKjqfmu2t5leterf5gd1gfp91wa R
shipterms_aud.REV FKlg4yd1bwwprylib03k4ykm51q R
so_aud.REV FKr930cu61ho8tqpdv8rv2wg4je R
soitem_aud.REV FKir2jruirik6jplu8qf4nj1qm6 R
stateconst_aud.REV FKopkha6vnuev02ks2uc5kiv7jc R
sysproperties_aud.REV FK1vlgi8bhmb4kab0vwknpg1pqu R
sysuser_aud.REV FK2jyg6lu5v1vqcbweq6txfiapw R
taxrate_aud.REV FKg0xxq3cq3ciiue1tacqcdu180 R
trackingdate_aud.REV FKihlcri49d40vylcl1n7lpp0us R
trackingdecimal_aud.REV FKogciposb282ayt2ibdssmt1v5 R
trackinginfo_aud.REV FKbfbvagfpasqssq6syfw7c3y7l R
trackinginfosn_aud.REV FKc8tyc738psgeifo2uaqrg2bfd R
trackinginteger_aud.REV FKvvedei3j58begi040fxgi7tq R
trackingtext_aud.REV FKa14p8t82bdsmpwxpu79teocxg R
uom_aud.REV FKfmxo9kywg2g98k5slr1t3u1cc R
uomconversion_aud.REV FK8h6k84vsyih0n0tmb0dpyy4b0 R
useraccess_aud.REV FKj5y9kaeifhm7cx7d56vm6c384 R
usergroup_aud.REV FKdrfj0b0focs7wy3spwdn993s9 R
usergrouprel_aud.REV FKqlrapx05wuv453lxov5py7irj R
userproperties_aud.REV FKjhea4ucg3d6s4dv46k3qair0s R
usertolg_aud.REV FKqgh5qd40njdwbqdcsd410ycgw R
vendor_aud.REV FKee0v1kejt5e00h5b2jfq2pvmu R
vendorcostrule_aud.REV FKbo20quuetisuj9fag7tls2m8l R
vendorparts_aud.REV FKm5lily7ephmxyl00p2kd87tdj R
watch_aud.REV FK27rcb0qt1w4t8din47ew2rbna R
wo_aud.REV FKf29rxik9qt4sr07les3rj0uaq R
woassignedusers_aud.REV FK7hxpinggyxy7ju0kstjbg5syw R
woinstruction_aud.REV FKhj4wsg80h2yi8muieesv64l9 R
woitem_aud.REV FKn5m3v7ud72q55s2jfl5sp62q R
xo_aud.REV FK2g6wqja568fg2e42pnmk6rux4 R
xoitem_aud.REV FKqth4qeqbwb8o24bedm5mo5rm0 R
modifiedUserId INT 10 √ null
mo.id Implied Constraint R
timestamp DATETIME 26 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation