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