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