Sample Database

The sample applications included in this documentation use the tables Person and Category. The table structure is configured using the ORM Element, which can be checked here.

For the sample, the tables are configured for the MySQL database server data types. You can modify these to other database data types. The structures below are for referential purposes.

create table Category (
    categoryID int primary key auto_increment,
    categoryName varchar(100) 
)
create table Person (
    personID int primary key auto_increment,
    name varchar(100),
    address varchar(250),
    phone varchar(20),
    email varchar(50),
    categoryID int,
    married tinyint default 0,
    birthdate date,
    monthlyIncome decimal(10,2),
    comments text,
    foreign key (categoryID) references Category (categoryID) on delete Set Null 
)

create index Person_categoryID on Person(categoryID)

MySQL Database Dump

Click on this link to download a MySQL dump file, which you can use to create and pre-populate these tables.

ORMs JSON String

To pre-populate the ORMs for the Category and Person tables, use the "Imp" option with the following JSON strings.

Category ORM JSON String

Person ORM JSON String

PreviousSilk Builder TrainingNextPlain Application

Last updated