musthave
테이블 (25)
Copy Of 댓글 (CopyOfreply2)
- 댓글 번호 (rno) — number(10,0) — NOT NULL
- 게시글 번호 (bno) — number(10,0) — NOT NULL
- 내용 (content) — varchar2(500) — NOT NULL
CopyOfreply
- rno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
board
- 일련번호 (num) — number — 기본 키 — NOT NULL
- 제목 (title) — varchar2(200) — NOT NULL
- 게시물의 제목 (content) — varchar2(2000) — NOT NULL
- 작성자의 아이디 (id) — varchar2(10) — 외래 키 → member.아이디 — NOT NULL
- 작성일 (postdate) — date — NOT NULL
- 조회수 (visitcount) — number(6)
food_recommend
- bno — number(10, 0) — NOT NULL
- title — varchar2(50) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writer — varchar2(15) — NOT NULL — 작성자
- regdate — date
- updatedate — date
- reply_cnt — number(10, 0)
- like — number(10, 0)
- visit_cnt — number(10, 0)
food_recommend_reply
- rno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
- bno — number(10,0) — NOT NULL
found_it
- bno — number(10, 0) — NOT NULL
- title — varchar2(50) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writer — varchar2(15) — NOT NULL — 작성자
- regdate — date
- updatedate — date
- reply_cnt — number(10, 0)
- like — number(10, 0)
- visit_cnt — number(10, 0)
found_it_reply
- rno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
- bno — number(10,0) — NOT NULL
like
- id — varchar2(15) — NOT NULL
- animal_num — number(10,0)
member
- 아이디 (id) — varchar2(10) — 기본 키 — NOT NULL
- 패스워드 (pass) — varchar2(10) — NOT NULL
- 이름 (name) — varchar2(30) — NOT NULL
- 가입날짜 (regidate) — date — NOT NULL
missing
- bno — number(10, 0) — NOT NULL
- title — varchar2(50) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writer — varchar2(15) — NOT NULL — 작성자
- regdate — date
- updatedate — date
- reply_cnt — number(10, 0)
- like — number(10, 0)
- visit_cnt — number(10, 0)
missing_reply
- rno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
- bno — number(10,0) — NOT NULL
my_pet_hospital_diary
- bno — number(10, 0) — NOT NULL
- title — varchar2(50) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writer — varchar2(15) — NOT NULL — 작성자
- regdate — date
- updatedate — date
- reply_cnt — number(10, 0)
- like — number(10, 0)
- visit_cnt — number(10, 0)
my_pet_hospital_diary_reply
- rno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
- bno — number(10,0) — NOT NULL
my_pet_show
- bno — number(10, 0) — NOT NULL
- title — varchar2(50) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writer — varchar2(15) — NOT NULL — 작성자
- regdate — date
- updatedate — date
- reply_cnt — number(10, 0)
- like — number(10, 0)
- visit_cnt — number(10, 0)
my_pet_show_reply
- rno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
- bno — number(10,0) — NOT NULL
protecting_animal
- animal_num — number(10,0)
- name — varchar2(30) — NOT NULL
- enter_day — date — NOT NULL
- protect_day — date — NOT NULL
- content — varcharr2(2000) — NOT NULL
- reply_cnt — number(10,0)
- like — number(10,0)
- visit_cnt — number(10,0)
reply
- rno — number(10,0) — NOT NULL
- bno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
reservation
- num — number(10, 0) — NOT NULL
- reser_time — date — NOT NULL
- regdate — date — NOT NULL
- phone — varchar2(30) — NOT NULL
- id — varchar2(15) — NOT NULL
- visit_reason — varchar2(10) — NOT NULL — 단순방문 또는 봉사
- visit_reason_content — varchar2(2000)
user
- id — varchar2(15) — NOT NULL
- password — varchar2(20) — NOT NULL
- name — varchar2(10) — NOT NULL
- staff — varchar2(2) — NOT NULL — y이면 관리자 N이면 일반유저
- phone — varchar2(30) — NOT NULL
vet_review
- bno — number(10, 0) — NOT NULL
- title — varchar2(50) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writer — varchar2(15) — NOT NULL — 작성자
- regdate — date
- updatedate — date
- reply_cnt — number(10, 0)
- like — number(10, 0)
- visit_cnt — number(10, 0)
vet_review_reply
- rno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
- bno — number(10,0) — NOT NULL
visit_reservation
- reservation_num — number(10, 0) — NOT NULL
- reservation_date — date — NOT NULL
- visit_date — date — NOT NULL
- id — varchar2(15) — NOT NULL
- reason — varchar2(400)
- volunteer — char(10) — 값이 Y라면 봉사방문으로 처리
- name — varchar2(20) — NOT NULL
- phone — varchar2(20) — NOT NULL
visit_reservation2
- bno — number(10, 0) — NOT NULL
- title — varchar2(50) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writer — varchar2(15) — NOT NULL — 작성자
- regdate — date
- updatedate — date
- reply_cnt — number(10, 0)
- like — number(10, 0)
- visit_cnt — number(10, 0)
walking
- bno — number(10, 0) — NOT NULL
- title — varchar2(50) — NOT NULL
- content — varchar2(2000) — NOT NULL
- writer — varchar2(15) — NOT NULL — 작성자
- regdate — date
- updatedate — date
- reply_cnt — number(10, 0)
- like — number(10, 0)
- visit_cnt — number(10, 0)
walking_reply
- rno — number(10,0) — NOT NULL
- content — varchar2(500) — NOT NULL
- bno — number(10,0) — NOT NULL