yeongn - 2021-03-14 08:04:09
Tables (6)
Appraisal (appraisal)
- ID (id) — int — Primary key — NOT NULL
- UserID (user_id) — int — Foreign key — NOT NULL
- Category (category) — varchar(255)
- ItemName (item_name) — varchar(255)
- Description (descriptsion) — varchar(255)
- ImgUrl (img_url) — varchar(255)
- CreatedAt (created_at) — datetime
- Price (price) — int
Appraisals Comments (appraisals_comments)
- ID (id) — int — Primary key — NOT NULL
- AppraisalID (appraisal_id) — int — Foreign key — NOT NULL
- userID (user_id) — int — Foreign key — NOT NULL
- Comment (comment) — varchar(255)
- CreatedAt (created_at) — datetime
Sales (sales)
- ID (id) — int — Primary key — NOT NULL
- UserId (user_id) — int — Foreign key — NOT NULL
- Category (category) — int
- ItemName (item_name) — varchar(255)
- UserPrice (user_price) — int
- Description (description) — varchar(255)
- imgUrl (img_url) — varchar(255)
- CreatedAt (created_at) — datetime
Sales Comments (sales_comments)
- ID (id) — int — Primary key — NOT NULL
- UserId (user_id) — int — Foreign key — NOT NULL
- SaleId (sale_id) — int — Foreign key — NOT NULL
- Comment (comment) — varchar(255)
- CreatedAt (created_at) — datetime
Users (users)
- ID (id) — int — Primary key — NOT NULL
- Nickname (nickname) — varchar(255)
- Email (email) — varchar(255)
- Social (social) — varchar(255)
- CreatedAt (created_at) — datetime
Users Appraisals Prices (users_appraisals_prices)
- ID (id) — int — Primary key — NOT NULL
- AppraisalID (appraisal_id) — int — Foreign key — NOT NULL
- userID (user_id) — int — Foreign key — NOT NULL
- Price (price) — int