Note : Project ini merupakan latihan
berikut sample schema api yang diinginkan
- Response sukses
{ "status": "NOT_FOUND/OK", "message": "success insert", "data": { "id": "xx", "name": "ccc" } } - Response gagal
{ "status": "NOT_FOUND/OK", "errors": { } }
- Database MYSQL
- Java 8
- Maven 3+
region |----|| country (One to Many)
create table region(
id int(5) primary key auto_increment,
name varchar(10) not null,
constraint uq_name unique(name)
)Engine=InnoDb;
create table country(
id int(5) primary key auto_increment,
code varchar(2) not null,
name varchar(20) not null,
region int(5) not null,
constraint uq_code unique(code),
foreign key (region) references region(id) on delete cascade on update cascade
)Engine=InnoDb;-
Application properties :
Setting nama database,username dan password