Database Schema

Column Descriptions

table "gps"

name		 type		 options		 length	 description			e.g.
---------------------------------------------------------------------------------
id			 int		 auto_increment	 -		 unique serial number
lat			 double		 not null		 -		 Latitude 				37.563722
lon			 double		 not null		 -		 Longitude 				126.93692
ts			 int		 not null		 -		 timestamp (sec unit)
children_idx varchar	 not null		 32		 idx of child (children.idx)

table "children"

name		 type		 options		 length	 description
---------------------------------------------------------------------------------
id			 int		 auto_increment	 -		 unique serial number
name		 varchar	 not null		 32		 children's name
phonenumber varchar	 not null		 11		 children's cell phone number
ts			 double		 not null		 -		 join timestamp (sec unit)
idx			 varchar	 not null		 32		 unique hash string

table "parent"

name		 type		 options		 length	 description
---------------------------------------------------------------------------------
id			 int		 auto_increment	 -		 unique serial number
name		 varchar	 not null		 32		 children's name
userid		 varchar	 not null		 32		 children's cell phone number
password	 varchar	 not null		 32		 children's cell phone number
ts			 double		 not null		 -		 join timestamp (sec unit)
children_idx	 varchar	 not null		 32		 unique hash string

SQL Dump

-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- 호스트: localhost
-- 처리한 시간: 13-11-27 16:20 
-- 서버 버전: 5.1.41
-- PHP 버전: 5.2.12

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- 데이터베이스: `watcher`
--
CREATE DATABASE `watcher` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `watcher`;

-- --------------------------------------------------------

--
-- 테이블 구조 `children`
--

CREATE TABLE IF NOT EXISTS `children` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `phonenumber` varchar(11) NOT NULL,
  `ts` double NOT NULL,
  `idx` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 테이블의 덤프 데이터 `children`
--


-- --------------------------------------------------------

--
-- 테이블 구조 `gps`
--

CREATE TABLE IF NOT EXISTS `gps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lat` double NOT NULL,
  `lon` double NOT NULL,
  `ts` int(11) NOT NULL,
  `children_idx` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 테이블의 덤프 데이터 `gps`
--


-- --------------------------------------------------------

--
-- 테이블 구조 `parent`
--

CREATE TABLE IF NOT EXISTS `parent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `userid` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `ts` double NOT NULL,
  `children_idx` varchar(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 테이블의 덤프 데이터 `parent`
--