potatoes
Tables (9)
Attendance (attendances)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- date (Field1) — date — NOT NULL
- coin_awarded (Field2) — smallint — NOT NULL
- created_at (common1) — timestamp — NOT NULL
- updated_at (common2) — timestamp — NOT NULL
Baekjoon (baekjoons)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- score (Field1) — bigint — NOT NULL
- created_at (common1) — timestamp — NOT NULL
- updated_at (common2) — timestamp — NOT NULL
Github (githubs)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- commit_num (Field1) — bigint — NOT NULL
- date (Field2) — date — NOT NULL
- created_at (common1) — timestamp — NOT NULL
- updated_at (common2) — timestamp — NOT NULL
Potato (potatoes)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK1) — bigint — Foreign key → User.id — NOT NULL
- potato_type_id (FK2) — smallint — Foreign key → PotatoType.id — NOT NULL
- is_selected (Field6) — Boolean — NOT NULL
- is_acquired (Field) — Boolean — NOT NULL
- created_at (common1) — timestamp — NOT NULL
- updated_at (common2) — timestamp — NOT NULL
PotatoType (potato_types)
- id (Key) — bigint — Primary key — NOT NULL
- potato_name (Field1) — varchar(255) — NOT NULL
- potato_description (Field2) — text — NOT NULL
Stack (stacks)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field1) — varchar(255) — NOT NULL
Todo (todos)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- task (Field1) — varchar(50) — NOT NULL
- is_done (Field2) — Boolean (default=false) — NOT NULL
- date (Field3) — date — NOT NULL
- created_at (common1) — timestamp — NOT NULL
- updated_at (common2) — timestamp — NOT NULL
User (users)
- id (Key) — bigint — Primary key — NOT NULL
- username (Field1) — varchar(255) unique — NOT NULL
- password (Field2) — varchar(255) — NOT NULL
- github_access_token (Field3) — varchar(255) — NOT NULL
- email (Field4) — varchar(255)
- profile_url (Field5) — varchar(255) — NOT NULL
- github_id (Field6) — varchar(255) — NOT NULL
- baekjoon_id (Field7) — varchar(255)
- nickname (Field8) — varchar(255) — NOT NULL
- potato_level (Field9) — smallint (default=1) — NOT NULL
- potato_exp (Field10) — smallint (default=0) — NOT NULL
- total_coins (Field11) — mediumint (default=0) — NOT NULL
- is_active (Field12) — Boolean (default=true) — NOT NULL
- is_staff (Field13) — Boolean (default=false) — NOT NULL
- is_superuser (Field14) — Boolean (default=false) — NOT NULL
- last_login (Field15) — timestamp — NOT NULL
- created_at (common1) — timestamp — NOT NULL
- updated_at (common2) — timestamp — NOT NULL
UserStack (user_stacks)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.id — NOT NULL
- stack_id (FK2) — bigint — Foreign key → Stack.id — NOT NULL