trip_fixie

Tables (5)

AREACODE (Untitled3)

  • AREANAME (Key) — VARCHAR — Primary key — NOT NULL
  • AREACODE (Field) — INT
  • AREALATITUDE (Field2) — DECIMAL(8,6)
  • AREALONGITUDE (Field3) — DECIMAL(9,6)

CHUSER

  • UID (Key) — VARCHAR — Primary key — NOT NULL
  • UEMAIL (Field) — VARCHAR
  • UNAME (Field2) — VARCHAR
  • UNICKNAMEV (Field3) — VARCHAR
  • UPROFILE (Field4) — MEDIUMTEXT

CONTENTLIST (Untitled2)

  • CONTENTID (Key) — INT — Primary key — NOT NULL
  • CTITLE (Field) — VARCHAR
  • CADDR (Field2) — VARCHAR
  • CTEL (Field3) — VARCHAR
  • CEVENTSTARTDATE (Field4) — DATE
  • CEVENTENDDATE (Field5) — DATE
  • CFIRSTIMAGE (Field6) — VARCHAR
  • CSECONDIMAGE (Field7) — VARCHAR
  • CLATITUDE (Field8) — DECIMAL(8,6)
  • CLONGITUDE (Field9) — DECIMAL(9,6)
  • CONTENTTYPEIDI (Field10) — NT

FAVORITE (Untitled)

  • FID (Key) — INT — Primary key — NOT NULL
  • UID (Key2) — VARCHAR — Foreign key → CHUSER.UID — NOT NULL
  • FTITLE (Field2) — VARCHAR
  • FSTART (Field3) — DATE
  • FEND (Field) — DATE
  • FAREA (Field4) — VARCHAR
  • FDATE (Field5) — VARCHAR
  • FNOTEPAD (Field6) — MEDIUMTEXT

FAVORITELIST (CopyOfUntitled2)

  • FID (Key2) — INT — Foreign key → FAVORITE.FID — NOT NULL
  • CONTENTID (Key) — INT — Foreign key → CONTENTLIST.CONTENTID — NOT NULL