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