ssafy

Tables (5)

Board (Untitled2)

  • articleNo (Key) — Int — Primary key — NOT NULL
  • user_id (Key2) — varchar(40) — Foreign key → User.user_id — NOT NULL
  • subject (Field) — varchar(40)
  • content (Field2) — varchar(300)
  • hit (Field3) — Int
  • registerTime (Field4) — timestamp

Trip (Untitled3)

  • contentId (Key) — Int — Primary key — NOT NULL
  • contentTypeId (Field) — Int
  • title (Field2) — varchar(40)
  • addr1 (Field3) — varchar(40)
  • addr2 (Field4) — varchar(40)
  • zipcode (Field5) — varchar(40)
  • tel (Field6) — varchar(40)
  • firstImage (Field7) — varchar(40)
  • firstImage2 (Field8) — varchar(40)
  • readcount (Field9) — Int
  • sidoCode (Field10) — Int
  • gugunCode (Field11) — Int
  • latitude (Field12) — Double
  • longitude (Field13) — Double
  • mLevel (Field14) — Int

TripPlan (Untitled4)

  • planNo (Key) — Int — Primary key — NOT NULL
  • user_id (Key2) — varchar(40) — Foreign key → User.user_id — NOT NULL

TripPlanDetail (Untitled5)

  • number (Key3) — Int — Primary key — NOT NULL
  • planNo (Key2) — Int — Foreign key → TripPlan.planNo — NOT NULL
  • user_id (Key22) — varchar(40) — Foreign key → TripPlan.user_id — NOT NULL
  • contentId (Key4) — Int — Foreign key → Trip.contentId — NOT NULL
  • content (Key) — varchar(300) — NOT NULL
  • date (Field) — timestamp

User (Untitled)

  • user_id (Key) — varchar(40) — Primary key — NOT NULL
  • user_name (Field) — varchar(40)
  • user_pwd (Field2) — varchar(40)
  • email_id (Field3) — varchar(40)
  • email_domain (Field4) — varchar(40)
  • Field5 — timestamp