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