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