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