Facetoface Signups Status Table Schema (facetoface_signups_status)


Description

Status of user signups, this table keeps the history for each user signup, no data is deleted

facetoface_signups_status table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
signupid BIGINT 19 null
facetoface_signups.id facesignstat_sig2_fk R
statuscode BIGINT 19 null
superceded BIT 1 null

0 means this is the current status
grade DECIMAL 10,5 √ null
createdby BIGINT 19 null
user.id facesignstat_cre2_fk R
timecreated BIGINT 19 null

Table contained -1 rows

facetoface_signups_status table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facesignstat_cre_ix Performance Asc createdby
facesignstat_sig_ix Performance Asc signupid

facetoface_signups_status table relationships

Close relationships within degrees of separation