Table arcasys.posper_customer
Kundendaten

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 255
posper_ticket.customer_id FK_ticket_cusotmer R
version int 10 Used for optimistic locking
name varchar 255
code varchar 255 -
contactName varchar 255  √  null -
fax varchar 255  √  null -
phone varchar 255  √  null -
street varchar 255  √  null -
city varchar 255  √  null -
postal varchar 255  √  null -
provState varchar 255  √  null -
tax_id varchar 255  √  null
posper_tax.id FK7232C5141EDEB803 R
not used
group_id varchar 255  √  null
posper_customergroup.id FK7232C5149EB64305 R
-
taxIdentifier varchar 255  √  null -
modifiers int 10  √  64 Activated modifiers, e.g. individual discount.
detailedInvoice bit 0  √  0 -
termOfPayment int 10  √  null -
alternativeInvoiceAddress bit 0  √  0 -
contactName1 varchar 255  √  null -
fax1 varchar 255  √  null -
phone1 varchar 255  √  null -
street1 varchar 255  √  null -
city1 varchar 255  √  null -
postal1 varchar 255  √  null -
provState1 varchar 255  √  null -
cardNumber varchar 45  √  null Unique ID of an identification medium like RFID card etc.
credit float 12  √  0 Allowed negative balance for customer account.
pin int 10  √  0 Security PIN for customer card
email varchar 255  √  null -
email1 varchar 255  √  null -
date1 date 10  √  null -
date2 date 10  √  null -
user_field_1 varchar 255  √  null -
user_field_2 varchar 255  √  null -
comment varchar 255  √  null -
active bit 0  √  null -
department varchar 255  √  null -
user_id int 10  √  null Reference to a Backoffice user.
language_id varchar 5  √  null
erp_updated_at datetime 19  √  null

Table contained 1 rows at Do Apr 25 17:50 MESZ 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
code Must be unique Asc code
tax_id Performance Asc FK7232C5141EDEB803
group_id Performance Asc FK7232C5149EB64305
name Performance Asc name

Close relationships  within of separation: