lol

Tables (5)

Image (image)

  • image_id — string — Primary key — NOT NULL
  • question_id — string — Foreign key → Question.question_id — NOT NULL
  • url — string

Judge (judge)

  • judge_id — string — Primary key — NOT NULL
  • question_id — string — Foreign key → Question.question_id — NOT NULL
  • user_id — string — Foreign key → User.user_id — NOT NULL
  • comment — string
  • nickname (Field) — string
  • tier (Field2) — enum
  • leftORright (Field3) — enum

Question (question)

  • question_id — string — Primary key — NOT NULL
  • user_id — string — Foreign key → User.user_id — NOT NULL
  • nickname1 (api로 id받아오기) — string
  • line1 (Field) — enum
  • tier1 (Field5) — enum
  • position1 (Field3) — string
  • nickname2 ('') — string
  • line2 (Field2) — enum
  • tier2 (Field6) — enum
  • description (Field8) — string
  • position2 (Field4) — string
  • timeStamp (Field7)

Review (review)

  • review_id — string — Primary key — NOT NULL
  • user_id — string — Foreign key → User.user_id — NOT NULL
  • target_id (라이엇api의 id)
  • review — string
  • score — int
  • timeStamp (Field)

User (user)

  • user_id — string — Primary key — NOT NULL
  • nickname (Field)
  • id (라이엇에서 끌어온 id)
  • puuid ('')