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