project1

Tables (8)

adopt

  • adopt number (bno) — number — Primary key — NOT NULL
  • pets number (petbno) — number — Foreign key → pets.pets number — NOT NULL
  • ID (id) — varchar2
  • title — varchar2
  • content — varchar2
  • image (imgurl) — varchar2
  • view count (viewcount) — number
  • creation date (regdate) — date
  • status — varchar2

comments

  • comment number (num) — number — Primary key — NOT NULL
  • news number (bno) — number — Foreign key → news.news number — NOT NULL
  • review number (bno2) — number — Foreign key → review.review number — NOT NULL
  • inquiry number (bno3) — number — Foreign key → inquiry.inquiry number — NOT NULL
  • adopt number (bno4) — number — Foreign key → adopt.adopt number — NOT NULL
  • enter number (bno5) — number — Foreign key → enter.enter number — NOT NULL
  • writer — varchar2
  • content — varchar2
  • creation date (wdate) — date

enter

  • enter number (bno) — number — Primary key — NOT NULL
  • title — varchar2
  • name — varchar2
  • content — varchar2
  • view count (viewcount) — number
  • creation date (regdate) — date
  • image (imgurl) — varchar2
  • status — number
  • enter date (enterdate) — date
  • kind — varchar2
  • pet's name (petname) — varchar2
  • pet's age (petage) — number
  • pet's gender (petgender) — varchar2

inquiry

  • inquiry number (bno) — number — Primary key — NOT NULL
  • title — varchar2
  • name — varchar2
  • content — varchar2
  • view count (viecount) — number
  • creation date (regdate) — date
  • image (imgurl) — varchar2
  • category — varchar2
  • email address (email) — varchar2

joinmember

  • member number (bno) — number — Primary key — NOT NULL
  • ID (id) — varchar2
  • password (pw) — varchar2
  • name — varchar2
  • birthday (birth) — date
  • gender — char
  • email address (email) — varchar2
  • phone number (phone) — varchar2

news

  • news number (bno) — number — Primary key — NOT NULL
  • title — varchar2
  • content — varchar2
  • creation date (regdate) — date
  • view count (viewcount) — number
  • image (imgurl) — varchar2
  • writer (name) — varchar2

pets

  • pets number (bno) — number — Primary key — NOT NULL
  • pet's name (petname) — varchar2
  • kind — varchar2
  • pet's age (petage) — number
  • pet's gender (petgender) — varchar2
  • enter date (enterdate) — date
  • done date (donedate) — date
  • apply date (applydate) — date
  • image (imgurl) — varchar2

review

  • review number (bno) — number — Primary key — NOT NULL
  • writer — varchar2
  • creation date (regdate) — date
  • content — varchar2
  • image (imgurl) — varchar2
  • title — varchar2
  • view count (viewcount) — number
  • count (cnt) — number