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