dog
Tables (16)
BLAME
- MM_NICKNAME — VARCHAR2(30) — Foreign key → BOARD.BWRITER — NOT NULL
- BLAME_NO — NUMBER — 신고번호;
- BTYPE_NAME — CHAR(50) — Foreign key → BOARD.BTYPE_NAME
- BLAME_BID — NUMBER
- BLAME_TYPE — CHAR(50)
- TARGET_NICKNAME — VARCHAR2(100)
- BLAME_DATE — DATE
- BLAME_CONTENT — VARCHAR2(2000)
- BLAME_IP — VARCHAR2(50)
BOARD
- BWRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
- BID — NUMBER — 게시판
- BTYPE_NAME — CHAR(50) — Foreign key → B_TYPE.BTYPE_NAME
- BTITLE — VARCHAR2(500) — NOT NULL
- BCONTENT — VARCHAR2(4000)
- B_ORIGINAL_FILENAME — VARCHAR2(100)
- B_RENAME_FILENAME — VARCHAR2(100)
- B_CREATE_DATE — DATE
- B_MODFIY_DATE — DATE
- BCOUNT — NUMBER
- B_RCOUNT — NUMBER
- BSTATUS — CHAR(2)
B_REPLY
- NICKNAME — VARCHAR2(30) — Foreign key → BOARD.BWRITER — NOT NULL
- B_RID — NUMBER — 게시글
- BTYPE_NAME — CHAR(50) — Foreign key → BOARD.BTYPE_NAME
- B_RCONTENT — VARCHAR2(400)
- B_REF_BID — NUMBER
- B_CREATE_DATE — DATE
- B_MODIFY_DATE — DATE
- B_STATUS — CHAR(1)
B_TYPE
- BTYPE_NAME — CHAR(50)
- BTYPE_NO — CHAR(2) — 구분번호;
MEMBER
- NICKNAME — VARCHAR2(30) — Primary key — NOT NULL
- ID — VARCHAR2(30) — NOT NULL — 회원아이디;
- PWD — VARCHAR2(100) — NOT NULL
- NAME — VARCHAR2(15)
- EMAIL — VARCHAR2(100)
- SEX — VARCHAR2(1)
- PHONE — VARCHAR2(13)
- ADDRESS — VARCHAR2(100)
- ENROLLDATE — DATE
- UPDATEDATE — DATE
- MSTATUS — VARCHAR2(1)
- SELFINTRO_HEAD — VARCHAR2(90)
- SELFINTRO_CONTENT — VARCHAR2(600)
- PROPIC — VARCHAR2(60)
- USER_LV — VARCHAR2(50)
- GRADE — VARCHAR2(50)
NAEGONG
- MEMBER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
- NID — NUMBER — 내공
- SORT — VARCHAR2(6)
- PRICE — VARCHAR2(1000)
- REF_QA_ID — NUMBER
- NAEGONGDATE — TIMESTAMP
NOTICE
- NWRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
- NID — NUMBER — 공지사항글
- TYPE_NAME — CHAR(50) — Foreign key → N_TYPE.TYPE_NAME
- NTITLE — VARCHAR2(500) — NOT NULL
- NCONTENT — VARCHAR2(4000)
- N_FILE_NAME — VARCHAR2(50)
- N_RFILE_NAME — VARCHAR2(50)
- N_DATE — DATE
- N_MODFIY_DATE — DATE
- NCOUNT — NUMBER
- NSTATUS — CHAR(2)
N_TYPE
- TYPE_NAME — CHAR(50)
- TYPE_NO — CHAR(2) — 구분번호;
PAYMENT
- MEMBER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
- PAYID — NUMBER — 결제
- SORT — VARCHAR2(6)
- PRICE — VARCHAR2(1000)
- PAYPG — VARCHAR2(20)
- PAYDATE — TIMESTAMP
PROGRESS
- PRO_WRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
- PRO_ID — NUMBER — 프로젝트
- PRO_QID — NUMBER
- PRO_ANSWERER — VARCHAR2(100) — NOT NULL
- PRO_DEADLINE — DATE
- PRO_PAY — NUMBER
- PRO_PROCESS — NUMBER
- PRO_STATUS — CHAR(2)
P_BOARD
- PWRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
- PID — NUMBER — 진행게시판
- P_PROID — NUMBER
- PTITLE — VARCHAR2(1000) — NOT NULL
- PCONTENT — VARCHAR2(4000)
- P_FILE_NAME — VARCHAR2(50)
- P_RFILE_NAME — VARCHAR2(50)
- P_DATE — DATE
- P_MODFIY_DATE — DATE
- PCOUNT — NUMBER
- PSTATUS — CHAR(2)
P_REPLY
- PRWRITER — VARCHAR2(30) — Foreign key → P_BOARD.PWRITER — NOT NULL
- PRID — NUMBER — 진행게시판
- REF_PID — NUMBER
- PRCONTENT — VARCHAR2(400)
- PR_DATE — DATE
- PR_MODIFY_DATE — DATE
- PR_STATUS — CHAR(1)
QA
- QA_WRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
- QA_ID — NUMBER — 문의사항
- QA_TITLE — VARCHAR2(200)
- QA_CONTENT — VARCHAR2(4000)
- QA_POINT — NUMBER
- QA_ORIGIN_FILE_NAME — VARCHAR2(50)
- QA_RENAME_FILE_NAME — VARCHAR2(50)
- QA_READCOUNT — NUMBER
- QA_CREATE_DATE — DATE
- QA_MODIFY_DATE — DATE
- QA_STATUS — VARCHAR2(1)
QAR
- QAR_WRITER — VARCHAR2(30) — Foreign key → QA.QA_WRITER — NOT NULL
- QAR_ID — NUMBER — 댓글번호;
- QAR_CONTENT — VARCHAR2(4000) — NOT NULL
- REF_QA_ID — NUMBER
- QAR_CREATE_DATE — DATE
- QAR_MODIFY_DATE — DATE
- QAR_STATUS — VARCHAR2(1)
REVIEW
- RWRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
- RID — NUMBER — 게시글번호;
- REF_PROID — NUMBER
- REF_QID — NUMBER
- RTITLE — VARCHAR2(100) — NOT NULL
- RCONTENT — VARCHAR2(4000)
- R_ORIGINAL_FILENAME — VARCHAR2(100)
- R_RENAME_FILENAME — VARCHAR2(100)
- RCOUNT — NUMBER
- R_CREATE_DATE — DATE
- R_MODIFY_DATE — DATE
- R_STATUS — VARCHAR2(1)
RE_REPLY
- RWRITER — VARCHAR2(30) — Foreign key → REVIEW.RWRITER — NOT NULL
- RID — NUMBER — 댓글번호;
- REF_RID — NUMBER
- RCONTENT — VARCHAR2(400)
- R_CREATE_DATE — DATE
- R_MODIFY_DATE — DATE
- R_STATUS — VARCHAR2(1)