Field
|
Type
|
Null
|
Default
|
Description
|
det_id
|
int(10)
|
Yes
|
NULL
|
This is the unique registration ID
|
det_evid
|
int(10)
|
Yes
|
NULL
|
This is the unique event ID that this registration was received for
|
det_webuid
|
int(10)
|
Yes
|
NULL
|
If not an anonymous registration, this field holds the member ID (web-site account holder) in the members table
|
det_regdate
|
datetime
|
Yes
|
NULL
|
This is a timestamp showing the date the registration was received
|
det_payment
|
float
|
Yes
|
NULL
|
If payment was captured, this field holds the payment amount confirmed (this is updated asynchronously after registration - usally by PP PDT or IPN) - users may update this as well
|
det_data0
|
varchar(1000)
|
Yes
|
NULL
|
This is the actual data entered in response to the first field in the registration form - the meaning of the entered data will depend on the data type defined for the corresponding field in the event definition. These will be sequenced as per the sequencing preferences in the events_table since the presentation order of fields in different than the physical order in the database - all other det_dataX fields have the same meaning
|
det_data1
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data2
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data3
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data4
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data5
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data6
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data7
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data8
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data9
|
varchar(1000)
|
Yes
|
NULL
|
|
det_stream
|
int(6)
|
Yes
|
0
|
For event_class and resource_reservations, there is a "stream" involved reflecting the timeslot being registered for - this is the integer offset of the stream starting at 0
|
det_evdate
|
datetime
|
Yes
|
NULL
|
If the event has a start date, it is replicated here. For classes this date will be the actual first date of classes registered for which is different than the start date of the event. The resource_reservations events this will be the future date that a resource has been reserved for
|
det_recurrence
|
float
|
Yes
|
0
|
|
det_note
|
varchar(5000)
|
Yes
|
NULL
|
|
det_data10
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data11
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data12
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data13
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data14
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data15
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data16
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data17
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data18
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data19
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data20
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data21
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data22
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data23
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data24
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data25
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data26
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data27
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data28
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data29
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data30
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data31
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data32
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data33
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data34
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data35
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data36
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data37
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data38
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data39
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data40
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data41
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data42
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data43
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data44
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data45
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data46
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data47
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data48
|
varchar(1000)
|
Yes
|
NULL
|
|
det_data49
|
varchar(1000)
|
Yes
|
NULL
|
|
det_p1
|
varchar(12)
|
Yes
|
0
|
|
det_t1
|
varchar(10)
|
Yes
|
NULL
|
|
det_p3
|
varchar(12)
|
Yes
|
0
|
|
det_t3
|
varchar(10)
|
Yes
|
NULL
|
|
det_txnid
|
varchar(100)
|
Yes
|
NULL
|
This is the unique PayPal transaction ID that confirmed payment - this is only present for transactions where payment has been confirmed
|
transid
|
varchar(100)
|
Yes
|
NULL
|
This is NeatClubs generated transaction ID randomly generated and guaranteed to be unique. This is used to recognize and avoid duplicated registration entries if users re-submit forms erroneously
|
program_year
|
int(4)
|
Yes
|
2007
|
used for classes only - this is the year of the class that a participant was registered into
|
handled
|
tinyint(1)
|
Yes
|
0
|
Boolean flag to track whether the administrator has handled this registration or not
|
tx_status
|
varchar(30)
|
Yes
|
Incomplete
|
|
det_amount_due
|
float
|
Yes
|
0
|
This is the calculated total amount due for the event registration. It is initially entered tentatively in the table - in cases where supplementary fees are made selectable, when the payment button is clicked a javascript / Ajax style update modifies the value to reflect any changes in the status of checkboxes before going to the payment subsystem.
|
resource_num
|
int(8)
|
Yes
|
0
|
Used only for resource reservations - this is the numeric resource that was registered for,
|
resource
|
varchar(100)
|
Yes
|
NULL
|
This is the name of the resource that was registered for
|
reserve_date
|
varchar(20)
|
Yes
|
NULL
|
For resource reservations only this is the date in MM/DD/YYYY format of the reservation
|
det_email_sent
|
tinyint(1)
|
Yes
|
0
|
|
det_start_date
|
varchar(20)
|
Yes
|
NULL
|
|
det_camp_attributes
|
text
|
Yes
|
NULL
|
|
det_camp_flags
|
text
|
Yes
|
NULL
|
|
det_camp_ex_attributes
|
text
|
Yes
|
NULL
|
|
det_nonpayment_warning_sent
|
tinyint(1)
|
Yes
|
0
|
|
det_nonpayment_debug_note_sent
|
tinyint(1)
|
Yes
|
0
|
|
det_brk_baseline_cost
|
float
|
Yes
|
0
|
Calculated as effective_cost * any price multiplier. This baseline cost will also reflect "per member" fee differentials (stored in $t)
|
det_brk_cost_impacts
|
float
|
Yes
|
0
|
The cumulative impact of options from price impact expressions (stored in $cost_impacts)
|
det_brk_tax1
|
float
|
Yes
|
0
|
Amount applied from tax1 ($tax1)
|
det_brk_tax1
|
float
|
Yes
|
0
|
Amount applied from tax2 ($tax2)
|
det_brk_supp1
|
float
|
Yes
|
0
|
Impact of supplementary fee 1 if present ($supp1_due)
|
det_brk_supp2
|
float
|
Yes
|
0
|
Impact of supplementary fee 2 if present ($supp2_due)
|
det_brk_supp3
|
float
|
Yes
|
0
|
Impact of supplementary fee 3 if present ($supp3_due)
|
det_brk_admin_fee
|
float
|
Yes
|
0
|
Amount of admin fee if present ($uplift)
|