pethealth1

Tables (3)

Calendar (캘린더일정(사건))

  • event_id (pk) — int — Primary key — NOT NULL
  • user_id (pk2) — int — Foreign key → User.user_id — NOT NULL
  • pet_id (fk(외래키)) — int
  • eventDate (일정(세부날짜)) — String
  • eventTime (세부시간) — String
  • eventType (일 유형..(병원예약..생일)) — String

CalendarEvent (연동해야 되는 사건(캘린더))

  • calEvent_id (pk) — int — Primary key — NOT NULL
  • event_id (pk2) — int — Foreign key → Calendar.event_id — NOT NULL
  • user_id (pk22) — int — Foreign key → Calendar.user_id — NOT NULL
  • petBirth (fk) — String
  • birth (fk(유저생일)) — String
  • visitHos (병원방문) — String
  • working (산책) — String

User (유저)

  • user_id (pk) — int — Primary key — NOT NULL
  • nickname (닉네임) — String
  • petInfo (펫정보) — String
  • birth (생일) — String
  • pwd (비밀번호) — String
  • email (이메일) — String
  • pet_id (고유펫) — int