TradeAgain
Tables (8)
ChatMessages
- MessageId — Long — Primary key — NOT NULL
- Text (text) — VARCHAR(255)
- SenderId (sender_Id) — Long — NOT NULL
- RecipientID (recipient_Id) — Long
- CreatedAt (created_at) — LocalDateTime
- UpdatedAt (updated_at) — LocalDateTime
Chatting Room (chatting_room)
- Chatting Room ID (Room Id) — Long — Primary key — NOT NULL
- RoomName (name) — VARCHAR(255)
- sellerId — Long
- buyerId — Long
- CreatedAt (created_at) — LocalDateTime
- UpdatedAt (updated_at) — LocalDateTime
- Photo Id (photo_id) — Long — Foreign key → Photo.Photo Id — NOT NULL
- MessageId — Long — Foreign key → ChatMessages.MessageId — NOT NULL
Member (member)
- Member Id (member_id) — Long — Primary key — NOT NULL
- Account (account) — VARCHAR(255) — NOT NULL
- Password (password) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- Phone (phone) — VARCHAR(11)
- Account Status (account_status) — VARCHAE(255)
Notification (notification)
- Notification Id (notification_id) — Long — Primary key — NOT NULL
- Notification Content (Notification_content) — VARCHAR(255)
- ReadAt (readAt) — LocalDateTime
- Member Id (member_id) — Long — Foreign key → Member.Member Id — NOT NULL
- CreatedAt (created_at) — LocalDateTime
- SendTimeAt (sendTime_At) — LocalDateTime
- RelatedURL (relatedURL) — VARCHAR(255)
Photo (photo)
- Photo Id (photo_id) — Long — Primary key — NOT NULL
- Url (url) — VARCHAR(255)
- Order (order) — INT
- CreatedAt (created_at) — LocalDateTime
- UpdatedAt (updated_at) — LocalDateTime
- Type (type) — VARCHAR(255)
- Product Id (product_id) — Long — Foreign key → Product.Product Id — NOT NULL
Product (product)
- Product Id (product_id) — Long — Primary key — NOT NULL
- Title (title) — VARCHAR(255)
- Content (content) — VARCHAR(255)
- CreatedAt (created_at) — LocalDateTime
- UpdatedAt (updated_at) — LocalDateTime
- Keywords (keyword) — VARCHAR(255)
- Member Id (member_id) — Long — Foreign key → Member.Member Id — NOT NULL
Review (review)
- Review Id (review_id) — VARCHAR(255) — Primary key — NOT NULL
- Reviewer (reviewer) — VARCHAR(255)
- Content (content) — VARCHAR(255)
- Score (score) — Double
- CreatedAt (created_at) — LocalDateTime
- UpdatedAt (updated_at) — LocalDateTime
- Member Id (member_id) — Long — Foreign key → Member.Member Id — NOT NULL
Transaction (transaction)
- Transaction Id (transaction id) — Long — Primary key — NOT NULL
- Buyer (buyer) — Long
- Price (price) — Long
- DisCountPrice (discount_price) — Long
- DisCountYn (discount_Yn) — boolean
- Transaction Status (transaction_status) — VARCHAR(255)
- CreatedAt (created_At) — LocalDateTime
- UpdatedAt (updated_At) — LocalDateTime
- Product Id (product_id) — Long — Foreign key → Product.Product Id — NOT NULL