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