rollingKorea

Tables (9)

COMMENT

  • commentId (comment_id) — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Foreign key → USER.userId — NOT NULL
  • nickname — VARCHAR — NOT NULL
  • content — VARCHAR
  • like — BIGINT
  • createdAt (created_at) — DATETIME
  • updatedAt (updated_at) — DATETIME

CONTACTUS (CopyOfREPLY)

  • contactUsId (contactUs_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → USER.userId — NOT NULL
  • content — VARCHAR
  • createdAt (created_at) — DATETIME
  • updatedAt (updated_at) — DATETIME
  • parentId (parent_id) — BIGINT
  • orderList (oreder_list) — BIGINT
  • fileData (file_data) — BLOB
  • fileName (file_name) — VARCHAR

IMAGE (Untitled)

  • imageId (image_id) — BIGINT — Primary key — NOT NULL
  • placeId (place_id) — BIGINT — Foreign key → PLACE.placeId — NOT NULL
  • imageData (image_data) — LONGBLOB

LIKE_PLACE

  • likePlaceId (like_place_id) — BIGINT — Primary key — NOT NULL
  • placeId (place_id) — BIGINT — Foreign key → PLACE.placeId — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → USER.userId — NOT NULL
  • createdAt (created_at) — DATETIME

LOGIN_HISTORY

  • loginHistoryId (login_history_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → USER.userId — NOT NULL
  • loginDate (login_date) — DATETIME
  • loginTime (login_time) — DATETIME
  • ipAddress (ip_address) — VARCHAR
  • tryNum (try_num) — CHAR

PLACE

  • placeId (place_id) — BIGINT — Primary key — NOT NULL
  • placeName (place_name) — VARCHAR
  • website — VARCHAR
  • latitude — DOUBLE
  • longitude — DOUBLE
  • imagePath (image_path) — VARCHAR
  • region — VARCHAR
  • createdAt (created_at) — DATETIME
  • updatedAt (updated_at) — DATETIME
  • countLike (count_like) — VARCHAR

RANKING (RANK)

  • rankingId (ranking_id) — BIGINT — Primary key — NOT NULL
  • placeId (place_id) — BIGINT — Foreign key → PLACE.placeId — NOT NULL
  • position — VARCHAR
  • countLike (count_like) — BIGINT
  • createdAt (created_at) — DATETIME

REPLY

  • replyId (reply_id) — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — Foreign key → USER.userId — NOT NULL
  • commentId (comment_id) — BIGINT — Foreign key → COMMENT.commentId — NOT NULL
  • content — VARCHAR
  • nickname — VARCHAR
  • createdAt (created_at) — DATETIME
  • like — VARCHAR
  • updatedAt (updated_at) — DATETIME

USER

  • userId (user_id) — BIGINT — Primary key — NOT NULL
  • loginId (login_id) — VARCHAR
  • userName (user_name) — VARCHAR
  • nickname — VARCHAR
  • password — VARCHAR
  • loginType (login_type) — VARCHAR
  • roleType (role_type) — VARCHAR
  • createdAt (created_at) — DATETIME
  • updatedAt (updated_at) — DATETIME
  • deletedAt (deleted_at) — DATETIME
  • birthday — DATETIME
  • location — VARCHAR
  • phoneNumber (phone_number) — VARCHAR