Rafhan Web Portal mailing list archives

========DB testing========= 1- [...]

by
Sidra Sattar
- 04/26/2019 10:49:38

========DB testing=========
1-tb email_templates empty
2-tb "sale channel" foriegn key lenght different at tb "partners"
3-tb "user" foriegn key lenght different at tb "orders"
4-tb "sale channel" foriegn key lenght different at tb "sales team"
5-"order no" null at tb "attachments"
6-"sale Person","sale Person id" and "code" null at tb "orders"
7-"price","tax","pTotal","deliverd qty" and invoiced qty" null at tb "order_lines"
8-"dealer id","order type","phone","mobile","city","street1" and "street 2" emty at tb "partners"
9-"email template id" and "shortCodes" null in tb "user email templates"
10-attribute(name,city,state,email, phone) lenghts not valid at tb "company setting"
11-attribute(name) lenghts not valid at tb "country"
12-attribute(title, subject) lenghts not valid at tb "email template"
13-attribute(name,sap material id) lenghts not valid at tb "material"
14-attribute(uom) lenghts not valid at tb "order onlines"
15-attribute(name,email, phone,mobile,street1,street2) lenghts not valid at tb "partners"
16-attribute(name,email,password) lenghts not valid at tb "users"
17-attribute(title, subject) lenghts not valid at tb "user email template"
18-no foreign key relation b/w tb "country(id)" and tb "company_setting(country id)" 
19-no foreign key relation b/w tb "user(id)" and tb "user email templates(user id)" 
20-no foreign key relation b/w tb "email template(id)" and tb "user email template(email template id)"