petCare

Tables (4)

CALNEDAR (CALENDAR)

  • ID (Key) — NOTNULL — Primary key — NOT NULL — NOTNULL
  • TITLE (Field) — NOTNULL
  • TYPE (Field2) — NOTNULL
  • CONTENT (Field3) — NOTNALL
  • START_TIME (Field4) — NOTNULL
  • END_TIME (Field5) — NOTNULL
  • USER_ID (Key2) — NOTNULL — Foreign key → User.ID — NOT NULL — NOTNULL

HOME

  • ID (Key) — NOTNULL — Primary key — NOT NULL — NOTNULL
  • EXTERNAL_TEMPERATURE (Field) — NOTNULL
  • INTERNAL_TEMPERATURE (Field2) — NOTNULL
  • HUMINITY (Field3) — NOTNULL
  • SOUND (Field4) — NOTNULL
  • USER_ID (Key2) — NOTNULL — Foreign key → User.ID — NOT NULL — NOTNULL

PET

  • ID (Key) — NOTNULL — Primary key — NOT NULL — NOTNULL
  • NAME (Field) — NOTNULL
  • AGE (Field2) — NOTNULL
  • BIRTHDAY (Field3) — NOTNULL
  • TYPE (Field4) — NOTNULL
  • NOTE (Field5) — NOTNULL
  • INSTRODUCTION (Field6) — NOTNALL
  • USER_ID (Key2) — NOTNULL — Foreign key → User.ID — NOT NULL — NOTNULL

User

  • ID (Key) — NOTNULL — Primary key — NOT NULL — NOTNULL
  • USERNAME (Field) — NOTNULL
  • EMAIL (Field2) — NOTNULL
  • PASSWORD (Field3) — NOTNULL
  • IMG_URL (Field4) — NOTNULL