✅ 목표 (Goal)

✅ 내용 (Contents)

create table `sensing_table` (
 `index` int not null auto_increment primary key,
 `dev_id` varchar(64) null default null,
 `location` varchar(128) null default null,
 `time` datetime null,
 `temp` double null default null,
 `humi` double null default null,
 `args` varchar(128) null default null
);

create table `sensing_table` (
`index` int not null auto_increment primary key,
`dev_grp` varchar(64) null default null,
`dev_uid` varchar(64) null default null,
`dev_loc` varchar(128) null default null,
`dev_date` datetime null,
`dev_volt` double null default null,
`dev_amp` double null default null,
`temp` double null default null,
`humi` double null default null,
`pm01` double null default null,
`pm25` double null default null,
`pm10` double null default null,
`ext01` double null default null,
`ext02` double null default null,
`ext03` double null default null,
`ext_str` varchar(128) null default null
);

create table `user_table` (
`index` int not null auto_increment primary key,
`id` varchar(64) null default null,
`pw` varchar(64) null default null
);

insert into user_table(id, pw) values ('aaa','aaa');
insert into user_table(id, pw) values ('bbb','bbb');
insert into user_table(id, pw) values ('ccc','ccc');