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