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