sysuser


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
bom.userId FK2xk48en3mt9b6ss1s8p3vxnb2 R
calcategory.lastChangedUserId FKoqlx6lyen5qhibm7jpmb75dbh R
calevent.lastChangedUserId FKlujxc10yq5di4ewiywcj0u30g R
cardonfile.lastChangedUserId FK_cardOnFile_userId R
currency.lastChangedUserId FKq56f0uga0w61ls5ogfs6u2rts R
customer.sysUserId Implied Constraint R
customer_aud.sysUserId Implied Constraint R
customerparts.lastChangedUserId FK1ylk5dwij5rmhh4ln7rttllct R
dataexport.lastChangedUserId FKbpy6bwb9f7kna0nwrsx3d861k R
fbschedule.lastChangedUserId FK6ixdd0aqrlt6tclp7gwbe241h R
guiproperties.userid fkuserid R
inventorylog.userId FKkhipim74kwxe0g2s6y60v54v9 R
mo.userId FKwpij5b0kijs636t63oga5qpw R
notification.userId FKNotificationUserId R
orderhistory.userId FKjnyeraly8759ek1vdepu8jwrx R
pick.userId FKj0extcfl38rrvmfaa9t2tltnq R
po.buyerId FKgixl2jgj96g06pvy04yn6utvw R
po.issuedByUserId FKPoIssuedByUser R
postransaction.userId FK1u8yhh18lpluk4fa2wbdw25tj R
pricingrule.userId FK9tlisi4j6au13jdu4x3bg0t85 R
receipt.userId FKjbkawab714fdfmel9ixnf0mkm R
report.lastChangedUserId FKm1wurlnqksvor8v2h82g8mkey R
report.userId FK36rnkeys3kxjas0p7cdmhuha8 R
reporttree.userId FKk7ymstp9wy2p2me9d4udbdyly R
rma.userId FKih4fubiqpbn2hbm9yq6gioces R
ship.shippedBy FK6eopar0962yqnbcrxi34d8jym R
so.createdByUserId FKSoCreatedByUserId R
so.salesmanId FKj68pnq4bc4buyden2dik5nqf5 R
usergrouprel.userId FKs5ox33341k8uindk5oqecnke9 R
userlog.userId FKtm6elmysljf6nfhherswh9ov6 R
userproperties.userId FK36y1jj4qy99jibivhmkrjgvvw R
usertolg.userId FK9r4c6jby7fkkph6s6icuqjc76 R
vendor.sysUserId Implied Constraint R
vendor_aud.sysUserId Implied Constraint R
vendorcostrule.userId FKg6bc62hmsios5yv36nthb2kdw R
vendorparts.userId FKarsct84sasqg7xfalyqef6pqq R
watch.sysUserId FKhbyb9s62b28hehakn3k3tuk0j R
watch_aud.sysUserId Implied Constraint R
wo.userId FK7auqtn6or120su6keupf6b14n R
woassignedusers.userId FK92x8g46u431ubmdymlmlvvgnv R
xo.userId FKj46qd352i4o2sfg7enr08msio R
activeFlag BIT 1 null
email VARCHAR 255 √ null
firstName VARCHAR 15 √ null
initials VARCHAR 5 √ null
lastName VARCHAR 15 √ null
phone VARCHAR 255 √ null
userName VARCHAR 100 null
userPwd VARCHAR 255 null
passwordLastModified DATETIME 26 √ null
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UKex2b9l58r42ga8v6eq8tfact2 Must be unique Asc userName

Relationships