Trip

Tables (3)

Notice (notice)

  • Article No (article_no) — VARCAR — Primary key — NOT NULL
  • User Id (user_id) — VARCAR — Primary key — NOT NULL
  • Title (title) — VARCAR
  • Contents (contents) — VARCAR
  • Register Time (register_time) — TIMESTAMP

Place (place)

  • Destination Id (destination_id) — INT — Primary key — NOT NULL
  • Place Name (place_name) — VARCAR
  • Address (address) — VARCAR
  • Photo (photo)

Users (users)

  • User Id (user_id) — VARCAR — Primary key — NOT NULL
  • User Name (user_name) — VARCAR
  • User Password (user_password) — VARCAR
  • Email Id (email_id) — VARCAR
  • Email Domain (email_domain) — VARCAR
  • Role (role) — VARCAR