Rank

Tables (5)

algorithm (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — varchar(8) — Foreign key → users.id — NOT NULL
  • boj_id (Field) — varchar(8)
  • boj_score (Field2) — int
  • point (Field3) — int

github (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • point (Key3) — int — Primary key — NOT NULL
  • user_id (Key2) — varchar(8) — Foreign key → users.id — NOT NULL
  • access_token (Field) — text
  • refresh_token (Field2) — text

grade (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — varchar(8) — Foreign key → users.id — NOT NULL
  • grade (Field) — float
  • point (Field2) — int

total_scores (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — varchar(8) — Foreign key → users.id — NOT NULL
  • score (Field2) — int

users (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Field) — varchar(8)
  • nickname (Field2) — varchar(20)
  • major (Field3) — varchar(20)
  • name (Field4) — varchar(10)
  • student_id (Field5) — int
  • social_email (Field6) — varchar(20)