dogEx1

Tables (13)

ADOPT_REVIEW

  • REVIEW_NO — NUMBER(100) — Primary key — NOT NULL
  • REVIEW_TITLE — VARCHAR2(50)
  • MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID
  • REVIEW_DOG_NAME — VARCHAR2(20)
  • REVIEW_CONTENT — VARCHAR2(500)
  • REVIEW_DATE — DATE

ADOPT_WANT_BOARD

  • WANT_NO — NUMBER(100) — Primary key — NOT NULL
  • WANT_TITLE — VARCHAR2(50)
  • MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID
  • WANT_CONTENT — VARCHAR2(500)
  • WANT_DATE — DATE

DOG_VIEW_BOARD

  • DOG_NO — NUMBER(100) — Foreign key → regist_dog.DOG_NO — NOT NULL
  • DOG_DATE — DATE — Foreign key → regist_dog.DOG_DATE
  • DOG_BREED — VARCHAR2(20) — Foreign key → regist_dog.DOG_BREED
  • DOG_NAME — VARCHAR2(20) — Foreign key → regist_dog.DOG_NAME
  • DOG_GENDER — VARCHAR2(20) — Foreign key → regist_dog.DOG_GENDER
  • DOG_PIC — CLOB — Foreign key → regist_dog.DOG_PIC
  • DOG_PIC_CURRENT — CLOB
  • DOG_FEATURE_CURRENT — VARCHAR2(20)
  • VIEW_CNT — NUMBER(100)

DROP_MEMBER

  • MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
  • DROP_DATE — DATE
  • DROP_REASON — VARCHAR2(30)

INFO_BOARD

  • INFO_NO — NUMBER(100) — Primary key — NOT NULL
  • MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID
  • INFO_TITLE — VARCHAR2(50)
  • INFO_CONTENT — VARCHAR2(500)
  • INFO_DATE — DATE

MEMBER

  • MEM_ID — VARCHAR2(20) — Primary key — NOT NULL
  • MEM_PW — VARCHAR2(20) — NOT NULL
  • MEM_NAME — VARCHAR2(10)
  • MEM_GENDER — VARCHAR2(10)
  • MEM_REG_NO — VARCHAR2(30)
  • MEM_MAIL — VARCHAR2(40)
  • MEM_PHONE — VARCHAR2(20)
  • MEM_ADDR — VARCHAR2(50)
  • MEM_JOIN_DATE — DATE

QNA_BOARD

  • QNA_NO — NUMBER(100) — Primary key — NOT NULL
  • MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID
  • QNA_TITLE — VARCHAR2(50)
  • QNA_CONTENT — VARCHAR2(500)
  • QNA_DATE — DATE

VOLUNTEER_PLAN_BOARD

  • VOL_TITLE (Key) — VARCHAR2(50) — Primary key — NOT NULL
  • VOL_DATE — DATE
  • VOL_TYPE — VARCHAR2(20)
  • VOL_CONTENT — VARCHAR2(500)

VOLUNTEER_WANT_BOARD

  • VOL_TITLE (Key) — VARCHAR2(50) — Foreign key → VOLUNTEER_PLAN_BOARD.VOL_TITLE — NOT NULL
  • MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID
  • VOL_NO — NUMBER(100) — NOT NULL
  • MEM_NAME — VARCHAR2(20)
  • MEM_GENDER — VARCHAR2(20)
  • MEM_PHONE — VARCHAR2(20)
  • VOL_TYPE — VARCHAR2(20)
  • VOL_DATE — DATE

admin

  • ADMIN_ID — VARCHAR2(20) — Primary key — NOT NULL
  • ADMIN_NAME — VARCHAR2(20)
  • ADMIN_PW — VARCHAR2(20)

adopt_dog

  • DOG_NO — NUMBER(100) — Foreign key → DOG_VIEW_BOARD.DOG_NO — NOT NULL
  • DOG_DATE — DATE — Foreign key → DOG_VIEW_BOARD.DOG_DATE
  • DOG_BREED — VARCHAR2(20) — Foreign key → DOG_VIEW_BOARD.DOG_BREED
  • DOG_NAME — VARCHAR2(20) — Foreign key → DOG_VIEW_BOARD.DOG_NAME
  • DOG_GENDER — VARCHAR2(20) — Foreign key → DOG_VIEW_BOARD.DOG_GENDER
  • DOG_PIC — CLOB — Foreign key → DOG_VIEW_BOARD.DOG_PIC
  • ADOPT_DATE — DATE
  • MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL

regist_dog

  • DOG_NO — NUMBER(100) — Primary key — NOT NULL
  • DOG_DATE — DATE — Primary key
  • DOG_BREED — VARCHAR2(20) — Primary key
  • DOG_NAME — VARCHAR2(20) — Primary key
  • DOG_GENDER — VARCHAR2(20) — Primary key
  • DOG_PIC — CLOB — Primary key
  • DOG_FEATURE — VARCHAR2(200)

report_board

  • REPORT_NO — NUMBER(100) — Primary key — NOT NULL
  • REPORT_TITLE — VARCHAR2(50)
  • REPORT_TYPE — VARCHAR2(20)
  • REPORT_BREED — VARCHAR2(20)
  • REPORT_GENDER — VARCHAR2(20)
  • REPORT_PLACE — VARCHAR2(50)
  • REPORT_FEATURE — VARCHAR2(200)
  • REPORT_PIC — CLOB
  • FOUND_DATE — VARCHAR2(20)
  • REPORT_DATE — DATE
  • MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID