rottenShoe v1
Tables (7)
Comments (load to sneaker's comments)
- id (commet_id) — bigInt — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → User.id — NOT NULL
- id (sneaker_id) — bigint — Foreign key → Sneaker.id — NOT NULL
- test (Field) — text
- created_time (create_time) — datetime
- updated_time (update_time) — datetime
CopOrDrop (sneaker evaluate table)
- id — bigint — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → User.id — NOT NULL
- id (sneaker_id) — bigint — Foreign key → Sneaker.id — NOT NULL
- choice (cop or drop) — boolean
Keyword (search_keyword_table)
- id — bigint — Primary key — NOT NULL
- id (sneaker_id) — bigint — Foreign key → Sneaker.id — NOT NULL
- keyword (search_word) — varchar
ScoreTable (load to sneaker's score)
- id — bigint — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → User.id — NOT NULL
- id (sneaker_id) — bigint — Foreign key → Sneaker.id — NOT NULL
- answer (cor or drop) — bigint
- created_time (create_time) — datetime
- update_time — datetime
Sneaker (sneaker's Table)
- id (sneaker_id) — bigint — Primary key — NOT NULL
- sneaker_name — varchar
- model_number — varchar
- brand (retail_brand) — varchar
- price (snaeker's price) — int
- total_count (total count of rating(cop or drop)) — int
- cop_count (count of cop) — int
- cop_percent (cop/total) — float
- retail_date — datetime
- img (sneaker's img(thumbnail))) — image
- sneaker_name_ko (sneaker_name of korean) — varchar
- view_count (board's views) — int
User (user's Table)
- id (user_id) — bigint — Primary key — NOT NULL
- email — varchar
- password — varchar
- nickname — varchar
- created_time (register time) — datetime
- updated_time (update time of user data) — datetime
UserMovementOfViews (user's personal data of movement)
- id — bigint — Primary key — NOT NULL
- id (sneaker_id) — bigint — Foreign key → Sneaker.id — NOT NULL
- id (user_id) — bigint — Foreign key → User.id — NOT NULL
- time (time of create user's data) — datetime