test

Tables (29)

certified

  • certifiedNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • challengeNum — NUMBER — Foreign key → challengeApply.challengeNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → challengeApply.userId — NOT NULL
  • subject — VARCHAR2(300) — NOT NULL
  • regDate — DATE — NOT NULL
  • content — CLOB — NOT NULL
  • accepyance — NUMBER(1)

challenge

  • challengeNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • challengeId — NUMBER — Foreign key → challengeList.challengeId — NOT NULL
  • subject — VARCHAR2(200) — NOT NULL
  • regDate — DATE — NOT NULL
  • modDate — DATE
  • content — CLOB — NOT NULL
  • hitCount — NUMBER — NOT NULL — DEFAULT 0
  • thumbnail — VARCHAR2(255) — 이미지 파일명

challengeApply

  • challengeNum — NUMBER — Foreign key → challenge.challengeNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL
  • applyDate — DATE — NOT NULL
  • applyState — VARCHAR2(30) — NOT NULL
  • complDate — DATE — NOT NULL
  • content — VARCHAR2(1000) — NOT NULL

challengeList

  • challengeId — NUMBER — Primary key — NOT NULL — 시퀀스
  • userId — NUMBER — Foreign key → 회원.회원번호 — NOT NULL
  • subject — VARCHAR2(300) — NOT NULL
  • content — CLOB — NOT NULL
  • point — NUMBER — NOT NULL
  • member — NUMBER — NOT NULL
  • startDate — DATE — NOT NULL
  • endDate — DATE — NOT NULL

evaluate

  • challengeNum — NUMBER — Foreign key → challengeApply.challengeNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → challengeApply.userId — NOT NULL
  • rating — NUMBER(1) — NOT NULL — DEFAULT 0

eventApply

  • eNum — NUMBER — Foreign key — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL
  • regDate — DATE — NOT NULL

eventList

  • num — NUMBER — Primary key — NOT NULL — 시퀀스
  • productName — VARCHAR2(300) — NOT NULL
  • productImg — VARVARCHAR2(255) — NOT NULL

freeBoard

  • num — NUMBER — Primary key — NOT NULL — 시퀀스
  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL
  • subject — VARCHAR2(200) — NOT NULL
  • regDate — DATE — NOT NULL
  • content — CLOB — NOT NULL
  • hitCount — NUMBER — NOT NULL — DEFAULT 0
  • notice — NUMBER(1) — NOT NULL — DEFAULT 0
  • nickName — VARCHAR2(30) — NOT NULL
  • thumbnail — VARCHAR2(255) — 이미지 파일명
  • acceptance — NUMBER(1) — DEFAULT 0

freeBoardReply

  • rNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • num — NUMBER — Foreign key → freeBoard.num — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL
  • content — VARCHAR2(4000) — NOT NULL
  • regDate — DATE — NOT NULL
  • answer — NUMBER — NOT NULL
  • nickName — VARCHAR2(30) — NOT NULL

freeBoardReplyLike

  • rNum — NUMBER — Foreign key → freeBoardReply.rNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL

noticeBoard

  • num — NUMBER — Primary key — NOT NULL — 시퀀스
  • tNum2 — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL
  • subject — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • regDate — DATE — NOT NULL
  • hitCount — NUMBER — NOT NULL — DEFAULT 0
  • nickName — VARCHAR2(30) — NOT NULL

photoBoard

  • num — NUMBER — Primary key — NOT NULL — 시퀀스
  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL
  • subject — VARCHAR2(200) — NOT NULL
  • regDate — DATE — NOT NULL
  • content — VARCHAR2(4000) — NOT NULL
  • hitCount — NUMBER — NOT NULL — DEFAULT 0
  • nickName — VARCHAR2(30) — NOT NULL
  • img — VARCHAR2(255) — NOT NULL

photoBoardLike

  • num — NUMBER — Foreign key → photoBoard.num — NOT NULL — 시퀀스
  • userId — VARCHAR2(50) — Foreign key → togetherApply.userId — NOT NULL

scrap

  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL

togetherApply

  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL
  • applyDate — DATE — NOT NULL
  • content — VARCHAR2(1000) — NOT NULL
  • acceptance — NUMBER(1) — NOT NULL

togetherLike

  • tNum — NUMBER — Foreign key → togetherList.tNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL

togetherList

  • tNum — NUMBER — Primary key — NOT NULL — 시퀀스
  • tagId — NUMBER — Foreign key → togetherTag.tagId — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL
  • name — VARCHAR2(200) — NOT NULL
  • subject — VARCHAR2(200) — NOT NULL
  • regDate — DATE — NOT NULL
  • content — CLOB — NOT NULL
  • memberCnt — NUMBER — NOT NULL
  • nickName — VARCHAR2(30) — NOT NULL
  • thumbnail — VARCHAR2(255) — 이미지 파일명

togetherTag

  • tagId — NUMBER — Primary key — NOT NULL — 시퀀스
  • tagName — VARCHAR2(1000) — NOT NULL

winner

  • eNum — NUMBER — Foreign key → eventApply.eNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → eventApply.userId — NOT NULL

winnerNotice

  • num — VARCHAR(255) — Primary key — NOT NULL — 시퀀스
  • eNum — NUMBER — Foreign key → winner.eNum — NOT NULL
  • userId — VARCHAR2(50) — Foreign key → winner.userId — NOT NULL
  • subject — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL

일상 게시판 (daily)

  • 글번호 (num) — NUMBER — Primary key — NOT NULL — 시퀀스
  • 아이디 (userId) — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL
  • 태그Id (tagId) — NUMBER — Foreign key → 일상게시판 태그.태그Id — NOT NULL
  • 제목 (subject) — VARCHAR2(200) — NOT NULL
  • 내용 (content) — CLOB — NOT NULL
  • 등록일 (regDate) — DATE — NOT NULL
  • 조회수 (hitCount) — NUMBER — NOT NULL — DEFAULT 0
  • 공지 (notice) — NUMBER — NOT NULL — DEFAULT 0
  • 닉네임 (nickName) — VARCHAR2(30) — NOT NULL

일상게시판 댓글 (dailyReply)

  • 댓글번호 (rNum) — NUMBER — Primary key — NOT NULL — 시퀀스
  • 글번호 (num) — NUMBER — Foreign key → 일상 게시판.글번호 — NOT NULL
  • 아이디 (userId) — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL
  • 내용 (content) — VARCHAR2(1000) — NOT NULL
  • 등록일 (regDate) — DATE — NOT NULL
  • 상위댓글번호 (answer) — NUMBER — NOT NULL
  • 닉네임 (nickName) — VARCHAR2(30) — NOT NULL

일상게시판 댓글 좋아요 (dailyReplyLike)

  • 댓글번호 (rNum) — NUMBER — Foreign key → 일상게시판 댓글.댓글번호 — NOT NULL
  • 아이디 (userId) — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL

일상게시판 좋아요 (dailyLike)

  • 글번호 (num) — NUMBER — Foreign key → 일상 게시판.글번호 — NOT NULL
  • 아이디 (userId) — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL

일상게시판 태그 (dTag)

  • 태그Id (tagId) — NUMBER — Primary key — NOT NULL — 시퀀스
  • 태그명 (tagName) — VARCHAR2(300) — NOT NULL

포인트 내역 (point)

  • pointNum — NUMBER — Primary key — NOT NULL — seq
  • userId — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL — unique
  • description — VARCHAR2(100)
  • regDate — DATE — NOT NULL — SYSDATE
  • curentPoint — NUMBER — NOT NULL
  • pointVar — NUMBER — NOT NULL
  • pointCate — NUMBER — NOT NULL

회원 (member)

  • 회원번호 (memberIdx) — NUMBER — Primary key — NOT NULL
  • 아이디 (userId) — VARCHAR2(50) — NOT NULL — unique
  • 닉네임 (nickName) — VARCHAR2(100) — NOT NULL
  • 비밀번호 (userPwd) — VARCHAR2(100) — NOT NULL
  • 가입일 (regDate) — DATE — NOT NULL — default sysdate
  • 수정일 (modifyDate) — DATE
  • 탈퇴 (secessionDate) — DATE
  • 로그인 실패 횟수 (loginFail) — NUMBER — NOT NULL — default 0
  • 최종로그인일자 (lastLogin) — DATE
  • 우편번호 (post) — NUMBER — NOT NULL
  • 기본주소 (town1) — VARCHAR2(100) — NOT NULL
  • 상세주소 (addr) — VARCHAR2(100) — NOT NULL
  • 추가주소 (town2) — VARCHAR2(100)
  • 아이디로그인가능여부 (enabled) — NUMBER — NOT NULL — defalut 1
  • 회원권한 (membership) — NUMBER — NOT NULL — defalut 10

회원권한 (memberAuthority)

  • 권한 (authority) — VARCHAR2(100) — Primary key — NOT NULL
  • 아이디 (userId) — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL

회원상세 (memberDetail)

  • 아이디 (userId) — VARCHAR2(50) — Foreign key → 회원.회원번호 — NOT NULL
  • 이름 (userName) — VARCHAR2(30) — NOT NULL — NOT NULL
  • 생일 (birth) — DATE — NOT NULL — NOT NULL
  • 이메일 (email) — VARCHAR2(100)
  • 소개 (comment) — VARCHAR2(300)
  • 매너점수 (userManner) — number — default