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)