mqops_tot_summary

288 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 37 null
user_id VARCHAR 36 √ null
mode TINYINT 3 √ null
venue_tot VARCHAR 200 √ null
ecosystem_id VARCHAR 45 √ null
tot_id VARCHAR 36 √ null
start_date DATE 10 √ null
end_date DATE 10 √ null
created_at TIMESTAMP 19 √ CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null
tenant_id VARCHAR 36 √ a287c91d-c8ff-4448-8d96-906d4654b6f2
other_tot VARCHAR 200 √ null
other_ecosystem VARCHAR 200 √ null
conducted_by INT 10 √ null
conducted_by_user TEXT 65535 √ null
other_conducted_by VARCHAR 200 √ null
learning_lab VARCHAR 500 √ null
other_objectives TEXT 65535 √ null
tot_photo1 VARCHAR 100 √ null
tot_photo2 VARCHAR 100 √ null
tot_report_template VARCHAR 100 √ null
tot_participant_details VARCHAR 100 √ null
other_stakeholder VARCHAR 50 √ null
state_lead_approved SMALLINT 5 √ 0
finance_lead_approved SMALLINT 5 √ 0
m_and_e_team_approved SMALLINT 5 √ 0
final_pdf_document VARCHAR 100 √ null
finance_reject_reason TEXT 65535 √ null
state_reject_reason TEXT 65535 √ null
m_and_e_reject_reason TEXT 65535 √ null
name_of_tot VARCHAR 100 √ null
tot_form_pdf VARCHAR 100 √ null
service_request_number VARCHAR 250 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships