project
Tables (7)
Community (Untitled2)
- board-id — int — Primary key — NOT NULL
- user-id — varchar2(20) — Foreign key → User.user-id — NOT NULL
- title — varchar2(40)
- content — varchar2(100)
- createdate — date
- count — int
Notice/FAQ (CopyOfUntitled2)
- notice-id — int — Primary key — NOT NULL
- user-id — varchar2(20) — Foreign key → User.user-id — NOT NULL
- title — varchar2(40)
- content — varchar2(100)
- createdate — date
- role — int
Pet (Untitled3)
- pet-id — int — Primary key — NOT NULL
- user-id — varchar2(20) — Foreign key → User.user-id — NOT NULL
- species (품종) — varchar2(20)
- age (나이) — int
- gender (성별) — varchar2(2)
- allergy (알러지) — varchar2(20)
- etc (특이사항) — varchar2(40)
- neutered (중성화) — varchar2(2)
- img (프로필사진) — varchar2(40)
PetNote/Food/Activity/Health/Diary (CopyOfUntitled22)
- petnote-id — int — Primary key — NOT NULL
- content — varchar2(100)
- createdate — date
- pet-id — int — Foreign key → Pet.pet-id — NOT NULL
- role — int
Reply
- Key (reply-id) — int — Primary key — NOT NULL
- createdate — date
- content — varchar2(40)
- board-id — int — Foreign key → Community.board-id — NOT NULL
- user-id — varchar2(20) — Foreign key → User.user-id — NOT NULL
Reserv (Untitled4)
- reserv-id — int — Primary key — NOT NULL
- date — date
- pet-id — int — Foreign key → Pet.pet-id — NOT NULL
- user-id — varchar2(20) — Foreign key → User.user-id — NOT NULL
User (Untitled)
- user-id — varchar2(20) — Primary key — NOT NULL
- user-pwd — varchar2(20)
- user-name — varchar2(20)
- phone — varchar2(20)
- email — varchar2(20)
- addr — varchar2(40)
- role — int