Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Step 2 - Creating Your Tables

edited December 2011 in Getting Started

Introduction

Having created an app, now you're ready to create some database tables to store your app's data. Similar to creating your app, the process is broken down into steplets which we'll cover below.

image

a - Enter the title of your table

Begin by entering a title for your table. Seeing as the table stores a collection of related objects, it's a convention in Kumulos that your table names should be plural. For example, "Books" instead of "Book". Kumulos will enforce this rule when saving the table, so if you enter "Book" it will become "Books", so don't worry if you make a mistake.

b - Enter a brief description

You can enter a brief description of the table and what it stores in the table comments field.

Our example shows the creation of a "Books" table for our "Bookworm" app. This table will store various information relating to books including a title, publisher, author, ISBN and published date. We also store a flag to indicate if the book is available in a digital format.

c - Drag field types into the box below

To add fields to your table, you simply drag field types from the right into the blue box. When you drop the field type, it will become a field on your table.

image

Each field should have a unique title set, and you can add comments if you wish. If you decide you don't need a field, you can remove it by clicking the large red cross in the top right corner of the field.

image

To make your life a bit easier, Kumulos will add fields for the record's unique ID (called a primary key), its creation time, and the time it was last updated. We take care of setting up these fields and inserting their values so you don't have to.

The primary key will take the form of your singular table name plus "ID". For example, a "Users" table's primary key will be "userID".

d - Save

After adding your fields, you can save and create another table. Don't worry about getting your table exactly right first time, you can always come back and edit existing tables later.

Next Steps

When you're content with your table structures, you're ready for Step 3 - Creating your API methods

image



Sign In or Register to comment.