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