Below is a screenshot of how to create your database. Once you've got a backend cloudlet, you'll need to create a new SQLite database in it. If you want to reproduce the app, you can sign up for a LowCode CRUD cloudlet here. This is the part that says "references" in the above script. This concept is called a "foreign key" and implies that all your todo items belongs to a status item. In the above database DDL SQL you can see that each todo item belongs to a status item. Status integer not null references status(status_id) Todo_id integer not null primary key autoincrement,Ĭreated timestamp not null default current_timestamp, Status_id integer not null primary key autoincrement, The database we will be creating our app around can be found below. The app isn't as complex or rich as ClickUp, but it's definitely way beyond what most other TODO app tutorials will teach you. Below is a screenshot of what we will be creating.Īs you can see in the above screenshot, we've got TODO items associated with users, we've got due dates, multiple components, in addition to all CRUD verbs. Most importantly of course is that we will create our TODO app in 5 minutes. In this TODO app tutorial we will create a rich TODO app, with several database tables, business logic, multiple users, and authentication and authorisation. Most TODO tutorials you find online are simple.
0 kommentar(er)
