coca

Tables (16)

BLAME

  • BLAME_NO — NUMBER — Primary key — 신고번호;
  • MM_NICKNAME — VARCHAR2(30) — Foreign key → BOARD.BWRITER — NOT NULL
  • BTYPE_NAME — CHAR(50) — Foreign key → BOARD.BTYPE
  • BLAME_BID — NUMBER
  • BLAME_TYPE — CHAR(50)
  • TARGET_NICKNAME — VARCHAR2(100)
  • BLAME_DATE — DATE
  • BLAME_CONTENT — VARCHAR2(2000)
  • BLAME_IP — VARCHAR2(50)

BOARD

  • BID — NUMBER — Primary key — 게시판
  • BWRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
  • BTYPE (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

  • B_RID — NUMBER — Primary key — 게시글
  • B_RWRITER (NICKNAME) — VARCHAR2(30) — Foreign key → BOARD.BWRITER — NOT NULL
  • BTYPE_NAME — CHAR(50) — Foreign key → BOARD.BTYPE
  • 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) — Primary key
  • 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

  • NID — NUMBER — Primary key — 내공
  • MEMBER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
  • SORT — VARCHAR2(6)
  • PRICE — VARCHAR2(1000)
  • REF_QA_ID — NUMBER
  • NAEGONGDATE — TIMESTAMP

NOTICE

  • NID — NUMBER — Primary key — 공지사항글
  • NWRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
  • NTYPE (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) — Primary key
  • TYPE_NO — CHAR(2) — 구분번호;

PAYMENT

  • PAYID — NUMBER — Primary key — 결제
  • MEMBER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
  • SORT — VARCHAR2(6)
  • PRICE — VARCHAR2(1000)
  • PAYPG — VARCHAR2(20)
  • PAYDATE — TIMESTAMP

PROGRESS

  • PRO_ID — NUMBER — Primary key — 프로젝트
  • PRO_WRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
  • PRO_QID — NUMBER
  • PRO_ANSWERER — VARCHAR2(100) — NOT NULL
  • PRO_DEADLINE — DATE
  • PRO_PAY — NUMBER
  • PRO_PROCESS — NUMBER
  • PRO_STATUS — CHAR(2)

P_BOARD

  • PID — NUMBER — Primary key — 진행게시판
  • PWRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
  • 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

  • PRID — NUMBER — Primary key — 진행게시판
  • PRWRITER — VARCHAR2(30) — Foreign key → P_BOARD.PWRITER — NOT NULL
  • REF_PID — NUMBER
  • PRCONTENT — VARCHAR2(400)
  • PR_DATE — DATE
  • PR_MODIFY_DATE — DATE
  • PR_STATUS — CHAR(1)

QA

  • QA_ID — NUMBER — Primary key — 문의사항
  • QA_WRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
  • 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_ID — NUMBER — Primary key — 댓글번호;
  • QAR_WRITER — VARCHAR2(30) — Foreign key → QA.QA_WRITER — NOT NULL
  • QAR_CONTENT — VARCHAR2(4000) — NOT NULL
  • REF_QA_ID — NUMBER
  • QAR_CREATE_DATE — DATE
  • QAR_MODIFY_DATE — DATE
  • QAR_STATUS — VARCHAR2(1)

REVIEW

  • RID — NUMBER — Primary key — 게시글번호;
  • RWRITER — VARCHAR2(30) — Foreign key → MEMBER.NICKNAME — NOT NULL
  • 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

  • RID — NUMBER — Primary key — 댓글번호;
  • RWRITER — VARCHAR2(30) — Foreign key → REVIEW.RWRITER — NOT NULL
  • REF_RID — NUMBER
  • RCONTENT — VARCHAR2(400)
  • R_CREATE_DATE — DATE
  • R_MODIFY_DATE — DATE
  • R_STATUS — VARCHAR2(1)