20220805_DOG
Tables (11)
ADMIN
- ADMIN_ID — VARCHAR2(20) — Primary key — NOT NULL
- ADMIN_NAME — VARCHAR2(20) — NOT NULL
- ADMIN_PW — VARCHAR2(20) — NOT NULL
ADOPT_REVIEW
- REVIEW_NO — NUMBER(30) — Primary key — NOT NULL
- REVIEW_TITLE — VARCHAR2(50) — NOT NULL
- MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
- REVIEW_DOG_NAME — VARCHAR2(20) — NOT NULL
- REVIEW_CONTENT — VARCHAR2(500) — NOT NULL
- REVIEW_DATE — DATE — NOT NULL
ADOPT_WANT
- WANT_NO — NUMBER(30) — Primary key — NOT NULL
- WANT_TITLE — VARCHAR2(50) — NOT NULL
- MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
- WANT_CONTENT — VARCHAR2(500)
- WANT_DATE — DATE — NOT NULL
DOG
- DOG_NO — NUMBER(30) — Primary key — NOT NULL
- DOG_DATE — DATE — NOT NULL
- DOG_FEATURE — VARCHAR2(200)
- DOG_BREED — VARCHAR2(20)
- DOG_NAME — VARCHAR2(20)
- DOG_GENDER — VARCHAR2(20) — NOT NULL
- DOG_PIC — CLOB
- DOG_PIC_CURRENT — CLOB
- VIEW_CNT_BOARD — VARCHAR2(200)
- MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
- ADOPT_YN — NUMBER(1) — NOT NULL
- ADOPT_DATE — DATE — NOT NULL
DROP_MEMBER
- MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
- DROP_DATE — DATE — NOT NULL
- DROP_REASON — VARCHAR2(30)
INFO_BOARD
- INFO_NO — NUMBER(30) — Primary key — NOT NULL
- MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
- INFO_TITLE — VARCHAR2(50) — NOT NULL
- INFO_CONTENT — VARCHAR2(500) — NOT NULL
- INFO_DATE — DATE — NOT NULL
MEMBER
- MEM_ID — VARCHAR2(20) — Primary key — NOT NULL
- MEM_PW — VARCHAR2(20) — NOT NULL
- MEM_NAME — VARCHAR2(10) — NOT NULL
- MEM_GENDER — VARCHAR2(10) — NOT NULL
- MEM_REG_NO — VARCHAR2(30) — NOT NULL
- MEM_MAIL — VARCHAR2(40)
- MEM_PHONE — VARCHAR2(20) — NOT NULL
- MEM_ADDR — VARCHAR2(50) — NOT NULL
- MEM_JOIN_DATE — DATE — NOT NULL
QNA_BOARD
- QNA_NO — NUMBER(30) — Primary key — NOT NULL
- MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
- QNA_TITLE — VARCHAR2(50) — NOT NULL
- QNA_CONTENT — VARCHAR2(500) — NOT NULL
- QNA_DATE — DATE — NOT NULL
REPORT_BOARD
- REPORT_NO — NUMBER(30) — Primary key — NOT NULL
- REPORT_TITLE — VARCHAR2(50) — NOT NULL
- REPORT_TYPE — VARCHAR2(20) — NOT NULL
- REPORT_BREED — VARCHAR2(20)
- REPORT_GENDER — VARCHAR2(20) — NOT NULL
- REPORT_PLACE — VARCHAR2(50)
- REPORT_FEATURE — VARCHAR2(200)
- REPORT_PIC — CLOB
- FOUND_DATE — VARCHAR2(20)
- REPORT_DATE — DATE — NOT NULL
- MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
VOL_PLAN
- VOL_TITLE — VARCHAR2(50) — Primary key — NOT NULL
- VOL_DATE — DATE — NOT NULL
- VOL_TYPE — VARCHAR2(20) — NOT NULL
- VOL_CONTENT — VARCHAR2(500)
VOL_WANT
- VOL_NO — NUMBER(30) — Primary key — NOT NULL
- MEM_ID — VARCHAR2(20) — Foreign key → MEMBER.MEM_ID — NOT NULL
- VOL_TITLE — VARCHAR2(50) — Foreign key → VOL_PLAN.VOL_TITLE — NOT NULL