Wetravel

Tables (4)

Untitled (travel_user(회원))

  • Key — Primary key — NOT NULL
  • Field (seq_id) — int
  • Field2 (email) — varchar
  • Field3 (pass_word) — varchar
  • Field4 (nick_name) — varchar

Untitled (travel(여행))

  • Key — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field6 (title)
  • Field2 (content)
  • Field3 (insert_date)
  • Field4 (update_date)
  • Field5 (address)

Untitled (file(파일업로드))

  • Key — Primary key — NOT NULL
  • Field (type)
  • Field (ref_id)
  • Field (url)

Untitled2 (commnet(여행댓글))

  • Key — Primary key — NOT NULL
  • Key (user_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (travel_id) — Foreign key → Untitled.Key — NOT NULL
  • Field2 (content)
  • Field3 (insert_date)