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