shareit proto

Tables (11)

BaseEntity (base_entity)

  • createdAt (created_at) — TIMESTAMP
  • updatedAt (updated_at) — TIMESTAMP
  • createdBy (created_by)
  • updatedBy (updated_by)
  • activeStatus (active_status) — ENUM

Campus (campus)

  • campusId (id) — BIGINT — Primary key — NOT NULL
  • campusName — ENUM

Chat (chat)

  • chatId (id) — BIGINT — Primary key — NOT NULL
  • memberId (id2) — BIGINT — Foreign key → Member.memberId — NOT NULL — Auto Generated
  • chatRoomId (id3) — BIGINT — Foreign key → ChatRoom.chatRoomId — NOT NULL
  • content — VARCHAR(255)
  • Field

ChatMember (chat_member)

  • chatMemberId (id) — BIGINT — Primary key — NOT NULL
  • memberId (member_id) — BIGINT — Foreign key → Member.memberId — NOT NULL — Auto Generated
  • chatRoomId (chat_room_id) — BIGINT — Foreign key → ChatRoom.chatRoomId — NOT NULL

ChatRoom (chat_room)

  • chatRoomId (id) — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255)

Like (like)

  • likeId (id) — BIGINT — Primary key — NOT NULL
  • memberId (id2) — BIGINT — Foreign key → Member.memberId — NOT NULL — Auto Generated
  • postId (id3) — BIGINT — Foreign key → Post.postId — NOT NULL

Member (member)

  • memberId (id) — BIGINT — Primary key — NOT NULL — Auto Generated
  • campusId (id2) — BIGINT — Foreign key → Campus.campusId — NOT NULL
  • email — VARCHAR(50)
  • password — VARCHAR(255)
  • username — VARCHAR(50)
  • cp — VARCHAR(50)
  • userRole (user_role) — ENUM
  • address — VARCHAR(255)
  • profileImage (profile_image) — VARCHAR(255)
  • socialId (social_id) — BIGINT
  • refreshToken — VARCHAR(255)

Post (post)

  • postId (id) — BIGINT — Primary key — NOT NULL
  • memberId (member_id) — BIGINT — Foreign key → Member.memberId — NOT NULL — Auto Generated
  • campusId (id2) — BIGINT — Foreign key → Campus.campusId — NOT NULL
  • hashTag (hash_tag) — VARCHAR(255)
  • content — VARCHAR(255)
  • title — VARCHAR(255)

PostImage (post_image)

  • postImageId (id) — BIGINT — Primary key — NOT NULL
  • postId (post_id) — BIGINT — Foreign key → Post.postId — NOT NULL
  • imageKey (image_key) — VARCHAR(255)

Purchase (purchase)

  • purchaseId (id) — BIGINT — Primary key — NOT NULL
  • memberId (member_id) — BIGINT — Foreign key → Member.memberId — NOT NULL — Auto Generated
  • postId (post_id) — BIGINT — Foreign key → Post.postId — NOT NULL
  • expireDate (expire_date) — TIMESTAMP
  • Field

Review (review)

  • reviewId (id) — BIGINT — Primary key — NOT NULL
  • purchaseId — BIGINT — Foreign key → Purchase.purchaseId — NOT NULL