exp2

Tables (13)

Activity

  • MemberID — INT
  • Address — VARCHAR(255)

Address

  • Address — VARCHAR(255)
  • CertifiedRegion — VARCHAR(255)

Category

  • CategoryID — INT
  • CategoryName — VARCHAR(255)

Chat

  • MemberID — INT
  • PostID — INT

Interest

  • MemberID — INT
  • PriceChangeAmount — DECIMAL
  • InterestDate — DATE

Keyword

  • KeywordName — VARCHAR(255)
  • AlertMessage — TEXT

Ledger

  • YearMonth — CHAR(7)
  • TotalIncome — DECIMAL
  • TotalExpense — DECIMAL

Member

  • MemberID — INT
  • Name — VARCHAR(255)
  • MannerTemperature — FLOAT
  • Verified — BOOLEAN
  • PhoneNumber — VARCHAR(20)
  • Email — VARCHAR(255)

PriceChangeNotification

  • PriceChangeAmount — DECIMAL

Product

  • PostID — INT
  • PostTitle — VARCHAR(255)
  • PostContent — TEXT
  • SaleStatus — BOOLEAN
  • PostDate — DATE
  • SalePrice — DECIMAL
  • Public — BOOLEAN

ProductPhoto

  • PhotoID — INT
  • PostID — INT

Register

  • MemberID — INT
  • KeywordName — VARCHAR(255)

Transaction

  • MemberID — INT
  • PostID — INT
  • YearMonth — CHAR(7)