petpetpet

Tables (5)

activity

  • id — bigint — Primary key — NOT NULL
  • type — varchar(20)
  • reward — bigint

attendance_log

  • id — bigint — Primary key — NOT NULL
  • id (id2) — bigint — Foreign key → user.id — NOT NULL
  • gps_lst — decimal
  • gps_lng — decimal
  • wifi_ssid — varchar(100)
  • is_valid — boolean

pet

  • id — bigint — Primary key — NOT NULL
  • id (id2) — bigint — Foreign key → user.id — NOT NULL
  • name — varchar(20)
  • level — bigint
  • exp — decimal
  • created_at — datetime(6)
  • updated_at — datetime(6)

study_log

  • id — bigint — Primary key — NOT NULL
  • id (id2) — bigint — Foreign key → user.id — NOT NULL
  • qr_data — varchar(300)
  • image_url — varchar(300)
  • gpt_result — varchar(10)

user

  • id — bigint — Primary key — NOT NULL
  • login_id — varchar(20)
  • password — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)