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 ('')