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