Mood
Tables (15)
ALGORITHM (Untitled7)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- MatchTime (Field) — TIMESTAMP
- MatchGroup (Field2) — INT
- MaxDistance (Field3) — DOUBLE
- MaxAge (Field4) — INT
- MinAge (Field5) — INT
- Matching (Field6) — INT
- Distance (Field7)
BLOCK_INFO (Untitled3)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- BlockUid (Key2) — VARCHAR(32) — Primary key — NOT NULL
- BlcokPhNum (Key3) — VARCHAR(20) — Primary key — NOT NULL
- BlockUid (Field)
Do (CopyOfUntitled14)
- machine_uid (PK) — varchar(50) — Foreign key → Uid.machine_uid — NOT NULL
- water_quality_uid (FK) — varchar(50 — Foreign key → Uid.water_quality_uid — NOT NULL
- do_val (Field) — float
- logtime (Field2) — timestamp
- Latitude (Field3) — Double
- Longitude (Field4) — Double
- LocationENG (Field5) — varchar(100)
- LocationKor (Field6) — varchar(100)
HASHTAG (Untitled10)
- TagID (Key) — VARCHAR(32) — Primary key — NOT NULL
- Name (Field) — VARCHAR(32)
- Type (Field2) — BOOLEAN
- Field3
LIKE_INFO (Untitled11)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- PostID (Field) — VARCHAR(32)
- Field2
Load (Untitled14)
- machine_uid (PK) — varchar(50) — Foreign key → Uid.machine_uid — NOT NULL
- water_quality_uid (FK) — varchar(50 — Foreign key → Uid.water_quality_uid — NOT NULL
- load_val (Field) — float
- logtime (Field2) — timestamp
- Latitude (Field3) — Double
- Longitude (Field4) — Double
- LocationENG (Field5) — varchar(100)
- LocationKor (Field6) — varchar(100)
MATCHING (Untitled12)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- MoodDistance (Field) — DOUBLE
- Disable (Field2) — BOOLEAN
- Field3
Match_INFO (Untitled2)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- Uid (Key2) — VARCHAR(32) — Foreign key → USER_INFO.Uid — NOT NULL
- NickName (Field) — VARCHAR(13)
- LocationENG (Field2) — VARCHAR(100)
- Uresoect (Field3) — INT
- Ucontect (Field4) — INT
- Udate (Field5) — INT
- Ucommu (Field6) — INT
- Usex (Field7) — INT
- Uwork (Field8) — VARCHAR(100)
- Uhappy (Field9) — VARCHAR(100)
- Udating (Field10) — VARCHAR(100)
- MoodDistance (Field11) — DOUBLE
- ProfileIng (Field12) — VARCHAR(300)
POST_HASHTAG (Untitled9)
- PostID (Key) — VARCHAR(32) — Primary key — NOT NULL
- TagID (Field) — VARCHAR(32)
- Field2
POST_INFO (Untitled8)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- Post_Location (Field) — VARCHAR(20)
- PostTime (Field2) — TIMESTAMP
- Contents (Field3) — VARCHAR(100)
- LikeC (Field4) — INT
- CommentC (Field5) — INT
- PostIMG (Field6) — VARCHAR(300)
- PostID (Field7) — VARCHAR(32)
- Field8
REPORT_INFO (Untitled6)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- DestUid (Field) — VARCHAR(32)
- PostUid (Field2) — VARCHAR(32)
- Title (Field3) — BOOLEAN
- Contect (Field4) — BOOLEAN
- ReportType (Field5)
USER_INFO (Untitled)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- PhNum (Field) — VARCHAR(12)
- Latitude (Field2) — DOUBLE
- MatchGender (Field10) — INT
- Longitude (Field3) — DOUBLE
- LocationENG (Field5) — VARCHAR(100)
- Email (Field6) — VARCHAR(320)
- PW (Field7) — VARCHAR(20)
- NIckName (Field8) — VARCHAR(13)
- Birth (Field4) — CHAR(8)
- Gender (Field9) — BOOLEAN
- Matching (Field11) — INT
- ProfileIMG (Field12) — VARCHAR(300)
- ProfileIcon (Field13) — VARCHAR(300
- Field14
USER_NOTICE (Untitled5)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- Event (Field) — BOOLEAN
- Conversation (Field2) — BOOLEAN
- NewMSG (Field3) — BOOLEAN
- PreviewMSG (Field4) — BOOLEAN
- Like (Field5) — BOOLEAN
- Comment (Field6) — BOOLEAN
- Comment (Field7) — BOOLEAN
- Magazine (Field8) — BOOLEAN
USER_VIPTYPE (Untitled4)
- Uid (Key) — VARCHAR(32) — Primary key — NOT NULL
- VipType (Field) — INT
- LoginTime (Field2) — TIMESTAMP
- LoginNum (Field3) — TIMESTAMP
- VipStartDate (Field4) — TIMESTAMP
- VipEndDate (Field5) — TIMESTAMP
Uid (Untitled13)
- machine_uid (PK) — varchar(50) — Primary key — NOT NULL
- water_quality_uid (PK,FK) — varchar(50 — Primary key — NOT NULL