joinBigP
Tables (8)
AdminInfo (Untitled6)
- id (Key) — serial — Primary key — NOT NULL
- adminid (Field) — text
- password (Field2) — text
- accessToken (Field3) — text
BabyEmotion (Untitled3)
- id (Key) — serial — Primary key — NOT NULL
- baby_id (Key2) — serial — Foreign key → BabyInfo.id — NOT NULL
- user_id (Key22) — serial — Foreign key → BabyInfo.user_id — NOT NULL
- checkTime (Field) — timestamp
- emotion (Field2) — integer
BabyInfo (Untitled4)
- id (Key) — serial — Primary key — NOT NULL
- user_id (Key2) — serial — Foreign key → UserInfo.id — NOT NULL
- babyname (Field) — text
- babybirth (Field2) — timestamp
ChatInfo (Untitled2)
- id (Key) — serial — Primary key — NOT NULL
- user_id (Key2) — serial — Foreign key → UserInfo.id — NOT NULL
- requestTIme (Field) — timestamp
- request (Field2) — json
- response (Field3) — json
ConfigInfo (Untitled5)
- id (Key) — serial — Primary key — NOT NULL
- user_id (Key2) — serial — Foreign key → UserInfo.id — NOT NULL
- alarm (Field) — boolean
- dataeliminateduration (Field2) — integer
NoticeInfo (Untitled7)
- id (Key) — serial — Primary key — NOT NULL
- admin_id (Key2) — serial — Foreign key → AdminInfo.id — NOT NULL
- header (Field) — text
- body (Field2) — text
- footer (Field3) — text
UserInfo (Untitled)
- id (Key) — serial — Primary key — NOT NULL
- username (Field) — text
- email (Field2) — text
- password (Field3) — text
- method (Field4) — integer
- aliasname (Field6) — text
- profileImage (Field5) — bytea
- accessToken (Field7) — text
- refreshToken (Field8) — text
VerificationInfo (Untitled8)
- id (Key) — serial — Primary key — NOT NULL
- email (Field) — text
- code (Field2) — text