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)