Hi,
How would you setup the data base for a forms ?
I didn’t find any thing about it on the forum.
Actually my structure is :
-
- Data type (users) with
Fields 1 : name
Fields 2 : relation list of forms (multiple)
- Data type (users) with
-
- Data type (Forms) with
Fields 1 : ID Forms
Fields 2 : Relation with user (single)
Fields 3 : Relation with Questions (multiple)
- Data type (Forms) with
-
- Data type (Questions) with
Fields 1 : ID Questions
Fields 2 : Relation with Forms (single)
Fields 3 : Relation with answers (multiple)
- Data type (Questions) with
-
- Data type (Answers) with
Field 1 : ID answers
Fields 2 : type answer Text
Fields 3 : type answer Number
Fields 4 : type answer Image
Fields 5 : type answer Bool
Fields 6 : type answer Date
- Data type (Answers) with
I am really not sure my Data type Answer is the right way to do it.
Thanks for your help
Clément