Wish
Tables (30)
Copy Of Copy Of Untitled2 (wish_reliability( 위시 신뢰도 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no ( 누른 사람 )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (good_bad ( 신뢰도 )) — VARCHAR2(4)
- Field (click_date ( 누른 날짜 )) — DATE
Copy Of Untitled (small_category ( 소분류 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (big_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (small_name ( 이름 )) — VARCHAR2(60)
Copy Of Untitled2 (date_todo_comment( 데이트 투두 comment ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (content ( 일지 내용 )) — VARCHAR2(300)
- Field (write_date ( 작성일 )) — DATE
Copy Of Untitled3 (free_board_like ( 좋아요 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (free_board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no ( 누른 사람 )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (click_date ( 누른 날짜 )) — DATE
Member (member ( 회원 관련 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (id ( 아이디 )) — VARCHAR2(40)
- Field (pw ( 비밀번호 )) — VARCHAR2(200)
- Field (name ( 본명 )) — VARCHAR2(50)
- Field (phone ( 폰번호 )) — VARCHAR2(30)
- Field (email ( 이메일 )) — VARCHAR2(100)
- Field (join_date ( 가입일 )) — DATE
Untitled (message ( 메시지 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (from_member_no ( 보낸 사람 )) — VARCHAR2(40)
- Field (to_member_no ( 받는 사람 )) — VARCHAR2(40)
- Field (content ( 메시지 내용 )) — VARCHAR2(300)
- Field (read_check ( 읽었는지 )) — VARCHAR2(4)
- Field (delete_check ( 받는 사람 삭제여부 )) — VARCHAR2(4)
- Field (write_date ( 작성일 )) — DATE
Untitled (password_find ( 비밀번호 찾기 메일 인증번호 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (temp_password) — VARCHAR2(100)
Untitled (friends_group( 친구 그룹 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (member_no ( 본인 no )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (name ( 그룹이름 )) — VARCHAR(40)
- Field (content ( 어떤그룹인지 설명 )) — VARCHAR(100)
Untitled (Date_ToDo_reply ( 날짜별 투두리스트 댓글 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (comment) — VARCHAR2(100)
- Field (write_date) — DATE
Untitled (Location_comment ( 위치 평점, 리뷰 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (comment) — VARCHAR2(100)
- Field (grade) — VARCHAR2(10)
Untitled (Ranking_member ( 랭킹 멤버 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (member_id) — VARCHAR2(40)
- Field (friends_check) — VARCHAR2(10)
Untitled (member_category ( 멤버 카테고리 통합 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (small_category_no ( 소분류 )) — NUMBER — Foreign key → Copy Of Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
Untitled (question_reply ( 문의사항 답변 - 관리자 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (question_no) — NUMBER — Foreign key → Untitled2.Key — NOT NULL
- Field (content ( 답변 내용 )) — VARCHAR2(600)
- Field (write_date ( 답변일 )) — DATE
Untitled (free_board_reply_warning ( 댓글 신고 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (free_board_reply_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no ( 신고자 )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (content ( 신고 내용 )) — VARCHAR2(300)
- Field (write_date ( 작성일 )) — DATE
Untitled (wish_reply_warning ( 댓글 신고 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (wish_reply_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (content ( 신고 내용 )) — VARCHAR2(300)
- Field (write_date ( 작성일 )) — DATE
Untitled (Date_ToDo_reply_warning ( 댓글 신고 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (comment) — VARCHAR2(100)
- Field (write_date) — DATE
Untitled (wish_reply ( 위시 댓글 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no ( 댓글단 사람 )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (content ( 댓글 내용 )) — VARCHAR2(200)
- Field (write_date ( 작성일 )) — DATE
Untitled (epilogue ( 위시 후기 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (content ( 후기내용 )) — VARCHAR2(1000)
- Field (write_date ( 작성일 )) — DATE
Untitled (date_todo_image ( 데이트 투두 업로드 파일 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (file_name ( 파일이름 )) — VARCHAR2(50)
- Field (upload_date ( 업로드 날짜 )) — DATE
Untitled (Ranking ( 랭킹 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (people_number) — NUMBER
- Field (prize) — VARCHAR2(100)
Untitled (friends ( 친구 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (friends_group_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no ( 친구 no )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (content ( 친구 설명 )) — VARCHAR2(40)
- Field (friends_date ( 친구한 날 )) — DATE
Untitled (big_category ( 대분류 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Field (big_name ( 이름 )) — VARCHAR2(30)
Untitled (free_board_reply ( 자유게시판 댓글 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (free_board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no ( 댓글 단 사람 )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (content ( 댓글 내용 )) — VARCHAR2(200)
- Field (write_date ( 작성일 )) — DATE
Untitled (free_board ( 자유게시판 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (member_no ( 작성자 )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (title ( 제목 )) — VARCHAR2(100)
- Field (content ( 내용 )) — VARCHAR2(600)
- Field (read_count ( 조회수 )) — NUMBER
- Field (write_date ( 작성일 )) — DATE
Untitled (wish_like ( 좋아요 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (member_no ( 누른 사람 )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (click_date ( 누른 날짜 )) — DATE
Untitled (todo_schedule ( 날짜별 투두 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (todo_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (check ( 해당 날에 투두 체크 )) — VARCHAR2(4)
- Field (todo_day ( 개별 날짜 )) — DATE
Untitled (todo_location ( 투두 위치 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (todo_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (address ( 위치 주소 )) — VARCHAR2(500)
Untitled (todo ( 투두 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (wish_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (content ( 투두 내용 )) — VARCHAR2(200)
Untitled (wish ( 위시 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (member_no) — NUMBER — Foreign key → Member.Key — NOT NULL
- Key (small_category_no ( 소분류 )) — NUMBER — Foreign key → Copy Of Untitled.Key — NOT NULL
- Field (title ( 제목 )) — VARCHAR2(100)
- Field (access_option ( 공개 여부 )) — VARCHAR2(15)
- Field (read_count ( 조회수 )) — NUMBER
- Field (import_count ( 가져간 수 )) — NUMBER
- Field2 (reply_check ( 댓글 허용 )) — VARCHAR2(4)
- Field (start_date ( 시작일 )) — DATE
- Field (end_date ( 종료일 )) — DATE
- Field (quit_date ( 포기일 )) — DATE
- Field (write_date ( 작성일 )) — DATE
Untitled2 (question ( 문의사항 ))
- Key (no) — NUMBER — Primary key — NOT NULL
- Key (member_no ( 작성자 )) — NUMBER — Foreign key → Member.Key — NOT NULL
- Field (content ( 문의 내용 )) — VARCHAR2(600)
- Field (private_check ( 공개여부 )) — VARCHAR2(4)
- Field (write_date ( 작성일 )) — DATE