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