-- ----------------------------
-- Table structure for "ALEXLEE"."ACTIVE"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."ACTIVE";
CREATE TABLE "ALEXLEE"."ACTIVE" (
"ID" NUMBER(10) NOT NULL ,
"NAME" VARCHAR2(20 CHAR) NOT NULL ,
"HEAT" FLOAT NULL ,
"TIME" FLOAT NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of ACTIVE
-- ----------------------------
-- ----------------------------
-- Table structure for "ALEXLEE"."DAIRY"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."DAIRY";
CREATE TABLE "ALEXLEE"."DAIRY" (
"DATETIME" VARCHAR2(20 CHAR) NOT NULL ,
"TEXT" VARCHAR2(2000 CHAR) NULL ,
"SLEEPHOUR" FLOAT NULL ,
"MOOD" VARCHAR2(255 CHAR) NULL ,
"CIGARETTE" NUMBER(10) NULL ,
"WEIGHT" FLOAT NULL ,
"PRESSURE" VARCHAR2(255 BYTE) NULL ,
"BPHIGH" FLOAT NULL ,
"BPLOW" FLOAT NULL ,
"BS" FLOAT NULL ,
"TEACHER_ID" NUMBER(10) NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of DAIRY
-- ----------------------------
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-4-14', '123', '1', '1', '1', '1', null, '1', null, '1', null);
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-4-20', '今天心情好', '12', '好', '0', '44', null, '123', '112', '12', null);
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-2', '五一放假3天', '6', '好', '2', '44', '无', '120', '90', '222', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-1', '进', '1', '1', '1', '1', '11', '1', '1', '1', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-3', '今天心情好', '12', '好', '0', '44', '无', '120', '90', '170', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-4', '今天雾霾严重,呼吸不畅', '12', '好', '0', '44', '无', '120', '100', '132', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-5-15', '五一放假3天', '6', '好', '2', '44', '无', '120', '90', '222', '1');
INSERT INTO "ALEXLEE"."DAIRY" VALUES ('2014-6-12', '<span style="color:#337FE5;font-size:16px;">毕业论文无限修改中。。。</span>', '9', '好', '0', '44', '无', '120', '90', '222', '1');
-- ----------------------------
-- Table structure for "ALEXLEE"."DAIRY_ACTIVE"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."DAIRY_ACTIVE";
CREATE TABLE "ALEXLEE"."DAIRY_ACTIVE" (
"ACTIVE_ID" NUMBER(10) NOT NULL ,
"DAIRY_ID" VARCHAR2(20 CHAR) NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of DAIRY_ACTIVE
-- ----------------------------
-- ----------------------------
-- Table structure for "ALEXLEE"."DAIRY_FOOD"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."DAIRY_FOOD";
CREATE TABLE "ALEXLEE"."DAIRY_FOOD" (
"DAIRY_ID" VARCHAR2(20 CHAR) NOT NULL ,
"FOOD_ID" NUMBER(10) NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of DAIRY_FOOD
-- ----------------------------
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-4-14', '11');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-4-14', '12');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-4-20', '1');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-1', '1');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '5');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '15');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '16');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '17');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-15', '26');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '3');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '4');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '5');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '6');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-2', '7');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '1');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '6');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '12');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '14');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-3', '29');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-4', '2');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-4', '14');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-4', '18');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-5-4', '29');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '3');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '4');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '5');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '6');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '7');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '26');
INSERT INTO "ALEXLEE"."DAIRY_FOOD" VALUES ('2014-6-12', '27');
-- ----------------------------
-- Table structure for "ALEXLEE"."EXAM"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."EXAM";
CREATE TABLE "ALEXLEE"."EXAM" (
"ID" NUMBER(10) NOT NULL ,
"DATETIME" TIMESTAMP(6) NOT NULL ,
"SBP" VARCHAR2(255 CHAR) NULL ,
"DBP" VARCHAR2(255 CHAR) NULL ,
"BMI" VARCHAR2(255 CHAR) NULL ,
"WHR" VARCHAR2(255 CHAR) NULL ,
"BUN" VARCHAR2(255 CHAR) NULL ,
"UA" VARCHAR2(255 CHAR) NULL ,
"CREA" VARCHAR2(255 CHAR) NULL ,
"TG" VARCHAR2(255 CHAR) NULL ,
"CHOL" VARCHAR2(255 CHAR) NULL ,
"HDL" VARCHAR2(255 CHAR) NULL ,
"LDL" VARCHAR2(255 CHAR) NULL ,
"GLU" VARCHAR2(255 CHAR) NULL ,
"HCY" VARCHAR2(255 CHAR) NULL ,
"M_ALB" VARCHAR2(255 CHAR) NULL ,
"M_ALB_CREA" VARCHAR2(255 CHAR) NULL ,
"TEACHER_ID" NUMBER(10) NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of EXAM
-- ----------------------------
INSERT INTO "ALEXLEE"."EXAM" VALUES ('1', TO_TIMESTAMP(' 2014-05-02 14:01:26:000000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '130', '100', '13', '0.6', '6', '150', '50', '0.6', '3.68', '1.06', '2.3', '3.7', '20', '22', '13.7', '1');
INSERT INTO "ALEXLEE"."EXAM" VALUES ('3', TO_TIMESTAMP(' 2014-04-23 19:02:30:000000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '110', '90', '15', '0.6', '8', '135', '62', '0.5', '2.34', '1.45', '3.4', '4.6', '33', '35', '12.9', '1');
INSERT INTO "ALEXLEE"."EXAM" VALUES ('4', TO_TIMESTAMP(' 2014-05-22 19:04:14:000000', 'YYYY-MM-DD HH24:MI:SS:FF6'), '115', '97', '14', '0.5', '8', '158', '55', '0.6', '2.56', '1.67', '3.2', '4.8', '34', '23', '13.9', '1');
-- ----------------------------
-- Table structure for "ALEXLEE"."FOOD"
-- ----------------------------
-- DROP TABLE "ALEXLEE"."FOOD";
CREATE TABLE "ALEXLEE"."FOOD" (
"ID" NUMBER(10) NOT NULL ,
"NAME" VARCHAR2(20 CHAR) NOT NULL ,
"HEAT" FLOAT NULL ,
"CARBOHYDRATE" FLOAT NULL ,
"FAT" FLOAT NULL ,
"PROTEIN" FLOAT NULL ,
"FIBER" FLOAT NULL ,
"TYPE" NUMBER(10) NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
-- ----------------------------
-- Records of FOOD
-- ----------------------------
INSERT INTO "ALEXLEE"."FOOD" VALUES ('1', '豆浆', null, null, null, null, null, '1');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('2', '肉松面包', null, null, null, null, null, '2');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('3', '煎蛋', null, null, null, null, null, '3');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('4', '苹果', null, null, null, null, null, '4');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('5', '香煎排骨', null, null, null, null, null, '5');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('6', '清炒西兰花', null, null, null, null, null, '6');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('7', '米饭', null, null, null, null, null, '7');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('8', '玉米羹', null, null, null, null, null, '8');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('9', '家常豆腐', null, null, null, null, null, '9');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('10', '清炒苦瓜', null, null, null, null, null, '10');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('11', '小米粥', null, null, null, null, null, '11');
INSERT INTO "ALEXLEE"."FOOD" VALUES ('12', '馒头', null, null, null, null, null