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