for my tutorial

mongo1

{
  name: "Algorithmtut",
  url: "www.algorithmtut.com",
  page_like: 1467
}

mongo2

{
  name: "Algorithmtut",
  detail: {
     url: "www.algorithmtut.com",
     page_like: 1467
  }
}

mongo3

// site_collection
{
  _id: 12,
  name: "Algorithmtut",
  url: "www.algorithmtut.com",
  page_like: 1467
}

//owner_site_collection
{
 _id: 1,
 name: "John Doe",
 website: ObjectID('12') // site_collection ID
}

mongo4

Define: use can have many site

// user
{
 _id: 1,
 name: "John Doe",
}

// site
{
  _id: 12,
  name: "Algorithmtut",
  url: "www.algorithmtut.com",
  page_like: 1467,
  user_id : ObjectID('1') 
}

{
  _id: 33,
  name: "Google",
  url: "www.google.com",
  page_like: 1467,
  user_id: ObjectID('1') 
}

{
  _id: 43,
  name: "Simple",
  url: "www.simple.com",
  page_like: 1467,
  user_id: ObjectID('1') 
}

mongo5

Define: use can have many site

// user
{
 _id: 1,
 name: "John Doe",
 website: [ 
   {
     name: "Algorithmtut",
     url: "www.algorithmtut.com",
     page_like: 1467,
   }, {
    name: "Google",
    url: "www.google.com",
    page_like: 1467,
   }
 ]
}

mongo6

Define: use can have many site

// user
{
 _id: 1,
 name: "John Doe",
 website: [
    ObjectID('12'),
    ObjectID('33'),
    ObjectID('43')
 ]
}

// site
{
  _id: 12,
  name: "Algorithmtut",
  url: "www.algorithmtut.com",
  page_like: 1467,
}

{
  _id: 33,
  name: "Google",
  url: "www.google.com",
  page_like: 1467,
}

{
  _id: 43,
  name: "Simple",
  url: "www.simple.com",
  page_like: 1467,
}

sql

create table `users` (
  `id` int unsigned not null auto_increment,
  `name` varchar(100) not null,
   primary key(`id`)
);

create table `phone_numbers` (
  `id` int unsigned not null auto_increment,
  `user_id` int unsigned not null,
  `phone_number` varchar(25) not null,
  index pn_user_index(`user_id`),
  foreign key (`user_id`) references users(`id`) on delete cascade,
  primary key(`id`)
);


// simple data in users

{ | id: 1 | name: 'John Doe' | }

// simple data in phone_numbers

{ | id: 1 | user_id: 1 | }
{ | id: 2 | user_id: 1 | }
{ | id: 3 | user_id: 1 | }
{ | id: 4 | user_id: 1 | }