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