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