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