CapstonDesign

Tables (4)

Guardian (CopyOfUntitled3)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • household_id (Key2) — bigint(20) — Foreign key → Household.id — NOT NULL
  • name (Field) — varchar(255)
  • age (Field2) — int(3)
  • phone_number (Field3) — varchar(255)

Household (Untitled)

  • id (Key) — bigint(20 — Primary key — NOT NULL
  • address (Field) — varchar(255)
  • risk (Field2) — varchar(255)
  • resident_name (Field3) — varchar(255)
  • resident_age (Field4) — int(3)
  • resident_phone_number (Field5) — varchar(255)

Schedule (일정)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (Key3) — bigint(20) — Foreign key → User.id — NOT NULL
  • household_id (Key2) — bigint(20) — Foreign key → Household.id — NOT NULL
  • date (Field) — DateTime

User (복지사)

  • id (Key) — bigint(20) — Primary key — NOT NULL
  • email (Key2) — varchar(255) — NOT NULL
  • password (Field) — varchar(255)
  • name (Field2) — varchar(255)
  • phone_number (Field3) — varchar(255)