tripbook

Tables (10)

courseMedia

  • mediaIdx — int unsigned — Primary key — NOT NULL
  • courseIdx — int unsigned — Foreign key → tripCourse.courseIdx — NOT NULL
  • mediaUrl — text
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)

hashtag

  • hashtagIdx — int unsigned — Primary key — NOT NULL
  • tagName — varchar(30)
  • tagType — VARCHAR(255)
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)

region

  • regionIdx — int unsigned — Primary key — NOT NULL
  • courseIdx — int unsigned — Foreign key → tripCourse.courseIdx — NOT NULL
  • region1 — varchar(100)
  • region2 — varchar(100)
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)

tagCourseIdxRelationships

  • relationIdx — int unsigned — Primary key — NOT NULL
  • courseIdx — int unsigned — Foreign key → tripCourse.courseIdx — NOT NULL
  • hashtagIdx — int unsigned — Foreign key → hashtag.hashtagIdx — NOT NULL
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)

themaUserRelationships

  • relationIdx — int unsigned — Primary key — NOT NULL
  • userIdx — int unsigned — Foreign key → user.userIdx — NOT NULL
  • themeIdx — int unsigned — Foreign key → theme.themeIdx — NOT NULL
  • Field

theme

  • themeIdx — int unsigned — Primary key — NOT NULL
  • themeName — varchar(30)
  • themeImg — text
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)

trip

  • tripIdx — int unsigned — Primary key — NOT NULL
  • userIdx — int unsigned — Foreign key → user.userIdx — NOT NULL
  • themeIdx — int unsigned — Foreign key → theme.themeIdx — NOT NULL
  • tripTitle — varchar(100)
  • departureDate — date
  • arrivalDate — date
  • tripImg — text
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)

tripCourse

  • courseIdx — int unsigned — Primary key — NOT NULL
  • tripIdx — int unsigned — Foreign key → trip.tripIdx — NOT NULL
  • courseTitle — varchar(100)
  • comment — varchar(255)
  • courseDate — date
  • time — int
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)

user (tb_user)

  • userIdx — int unsigned — Primary key — NOT NULL
  • email — varchar(100)
  • password — varchar(200)
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)

userProfile

  • userProfileIdx — int unsigned — Primary key — NOT NULL
  • userIdx — int unsigned — Foreign key → user.userIdx — NOT NULL
  • nickName — varchar(30)
  • userImg — text — 유저 프로필 이미지
  • comment — varchar(255)
  • snsId — varchar(100)
  • createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  • status — varchar(10)