TIL

Tables (6)

bookmark (Untitled5)

  • id (Key) — Foreign key → tilog.id — NOT NULL
  • email (Key2) — Foreign key → tiler.email — NOT NULL
  • reg_ymdt (Field)

like (Untitled3)

  • email (Key) — Foreign key → tiler.email — NOT NULL
  • id (Key2) — Foreign key → tilog.id — NOT NULL
  • reg_ymdt (Field)

tag (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

tiler (Untitled2)

  • email (Key) — Primary key — NOT NULL
  • nickname (Field)
  • passwd (Field2)
  • job (Field3)
  • reg_ymdt (Field4)
  • profile (Field5)

tilog (Untitled)

  • id (Key) — Primary key — NOT NULL
  • timestamp (Field) — timestamp
  • reg_ymdt (Field2) — datetime
  • reg_ymd (Field3) — varchar
  • email (Field4) — varchar
  • content (Field5) — text
  • title (Field6) — varchar
  • thumb_img (Field7) — varchar
  • mod_ymdt (Field8)
  • tag_id (Field9)
  • Field10

tilog_template (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • content (Field)