MindTravel

Tables (10)

Item (item)

  • itemId (item_id) — Long — Primary key — NOT NULL
  • type — Character
  • name — Character

Member (member)

  • memberId (member_id) — Long — Primary key — NOT NULL
  • email — Character
  • nickname — Character
  • oauthServerType (oauth_server_type) — Character
  • oauthId (oauth_id) — Character
  • profileImgUrl (profile_img_url) — Character
  • role — Character — 상담사 인지 일반 유저인지 구분하기 위한

MemberItemInventory (member_item_inventory)

  • itemInventoryId (item_inventory_id) — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • itemId (item_id) — Long — Foreign key → Item.itemId — NOT NULL
  • stockQuantity (stock_quantity) — Int

MindSharePost (mind_share_post)

  • postId (post_id) — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • category — Character — NOT NULL
  • title — Character — NOT NULL
  • content — Character — NOT NULL
  • viewCount (view_count) — Long — NOT NULL

MindSharePostChildComment (mind_share_post_child_comment)

  • commentId (comment_id) — Character — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • tagMemberId (tag_member_id) — Long — Foreign key → Member.memberId
  • parentCommentId (parent_comment_id) — Long — Foreign key → MindSharePostComment.commentId — NOT NULL
  • content — Character

MindSharePostComment (mind_share_post_comment)

  • commentId (comment_id) — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • postId (post_id) — Long — Foreign key → MindSharePost.postId — NOT NULL
  • content — Character
  • isDeleted (is_deleted) — Boolean

MindSharePostLike (mind_share_post_like)

  • postId (post_id) — Long — Foreign key → MindSharePost.postId — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL

MoodRecord (mood_record)

  • moodRecordId (mood_record_id) — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • content — Character — NOT NULL
  • mood — Character — NOT NULL

StoreItem (consulting_item)

  • storeItemId (store_item_id) — Long — Primary key — NOT NULL
  • itemId (item_id) — Long — Foreign key → Item.itemId — NOT NULL
  • price — Int
  • quantity — Int

StoreOrder (store_order)

  • storeOrderId (store_order_id) — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • itemId (item_id) — Long — Foreign key → Item.itemId — NOT NULL
  • quantity — Int
  • price — Int
  • paymentId (payment_id) — Character
  • paymentType (payment_type) — Character
  • status — Character