potato

Tables (7)

Attendance (Untitled3)

  • Id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint
  • date (Field) — timestamp
  • coin_awarded (Field2) — smallint
  • Field3

Baekjoon (baekjoon)

  • Id (Key) — bigint — Primary key — NOT NULL
  • baekjoon_id (FK1) — varchar(20)
  • score (Field) — bigint
  • created_at (Field3) — timestamp
  • updated_at (Field2) — timestamp

Github (githubs)

  • Id (Key) — bigint — Primary key — NOT NULL
  • github_id (FK1) — varchar(250)
  • commit (Field) — bigint
  • created_at (Field3) — timestamp
  • updated_at (Field2) — timestamp

Potato (potatoes)

  • Id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK1) — bigint
  • potato_type (FK2) — smallint
  • potato_nickname (Field) — varchar(20)
  • potato_level (Field3) — smallint
  • potato_exp (Field4) — smallint — 깃허브 커밋, 특별이벤트
  • potato_coin (Field5) — smallint — 출석체크, 백준, 프로그래머스 점수
  • is_selected (Field6) — Boolean
  • Field2

Potato_type (potato_types)

  • Id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • level (Field2) — smallint
  • image (Field3) — varchar(250)
  • description (Field4) — text
  • Field5

Programmers (programmers)

  • Id (Key) — bigint — Primary key — NOT NULL
  • programmers_id (FK1) — varchar(20)
  • score (Field) — bigint
  • created_at (Field3) — timestamp
  • updated_at (Field2) — timestamp

User (users)

  • Id (Key) — bigint — Primary key — NOT NULL
  • auth_id (Field) — bigint
  • name (Field2) — varchar(20)
  • nickname (Field3) — varchar(20)
  • profile_url (Field4) — varchar(250)
  • github_id (Field5) — varchar(250)
  • email (Field6) — varchar(50)
  • phonenum (Field7) — varchar(50)
  • description (Field8) — text
  • birthday (Field9) — timestamp
  • created_at (Field10) — timestamp
  • updated_at (Field11) — timestamp
  • programmers_id (Field12) — varchar(20) — 해시화된 암호를 그대로 가져다가 자동으로 사용가능한지
  • baekjoon_id (Field13) — varchar(20)
  • Field14