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)