Estudy
Tables (25)
AREA (지역)
- CODE (지역코드) — varchar — Primary key — NOT NULL
- COMM_CODE (도시코드) — varchar — Foreign key → COMMON.COMM_CODE — NOT NULL
- NAME (지역명) — varchar
- SORT (정렬순서) — int
BOARD_GROUP (멀티게시판(관리자용))
- ID (게시판 그룹번호) — long — Primary key — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
- NAME (게시판 그룹명) — varchar
- DELETE_FLAG (삭제 여부) — char
- USE_FLAG (사용여부) — char
- READ_ONLY (글쓰기 가능여부) — char
- CREATE_DATE (생성 일자) — DateTime
BOARD_LIKE (좋아요)
- ID (좋아요번호) — long — Primary key — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
- BOARD_ID (글번호) — long — Foreign key → COMMUNITY_BOARD.ID — NOT NULL
- BOARD_GROUP_ID (게시판 그룹번호) — long — Foreign key → COMMUNITY_BOARD.BOARD_GROUP_ID — NOT NULL
- HEART_DATE (발생일자) — long
COMMON (공통)
- COMM_HEAD (대분류) — varchar — Primary key — NOT NULL
- COMM_CODE (분류코드) — varchar — Primary key — NOT NULL
- COMM_NAME (분류이름) — varchar
- SORT (정렬순서) — int
COMMUNITYBOARD_REPLY (댓글)
- ID (댓글번호) — long — Primary key — NOT NULL
- BRD_ID (글번호) — long — Foreign key → COMMUNITY_BOARD.ID — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → COMMUNITY_BOARD.PEOPLE_ID — NOT NULL
- BOARD_GROUP_ID (게시판 그룹번호) — long — Foreign key → COMMUNITY_BOARD.BOARD_GROUP_ID — NOT NULL
- ID (모임번호) — long — Foreign key → COMMUNITY_BOARD.ID — NOT NULL
- ID (오프모임키) — long — Foreign key → COMMUNITY_BOARD.ID — NOT NULL
- PEOPLE_ID (사용자번호2) — long — Foreign key → COMMUNITY_BOARD.PEOPLE_ID — NOT NULL
- MEMO (댓글내용) — long
- PARENT (상위댓글) — long
- DEPTH (댓글깊이) — long
- ORDER (순서) — long
- CREATE_DATE (최초작성일자) — DateTime
- UPDATE_DATE (수정일자) — DateTime
- DELETE_FLAG (댓글삭제여부) — char
COMMUNITY_BOARD (게시판)
- ID (글번호) — long — Primary key — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
- BOARD_GROUP_ID (게시판 그룹번호) — long — Foreign key → BOARD_GROUP.ID — NOT NULL
- ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- ID (오프모임키) — long — Foreign key → MEETUP.ID — NOT NULL
- PEOPLE_ID (사용자번호2) — long — Foreign key → MEETUP.PEOPLE_ID — NOT NULL
- TITLE (제목) — varchar
- MEMO (설명(내용)) — longtext
- CREATE_DATE (최초작성일자) — DateTime
- UPDATE_DATE (수정일자) — DateTime
- DELETE_FLAG (삭제여부) — char
- HEART (좋아요수) — long
COMMUNITY_FILE (자료)
- ID (파일번호) — long — Primary key — NOT NULL
- BOARD_ID (글번호) — long — Foreign key → COMMUNITY_BOARD.ID — NOT NULL
- MOIM_ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- BOARD_GROUP_ID (게시판 그룹번호) — long — Foreign key → COMMUNITY_BOARD.BOARD_GROUP_ID — NOT NULL
- ID (오프모임키) — long — Foreign key → COMMUNITY_BOARD.ID — NOT NULL
- PEOPLE_ID (사용자번호2) — long — Foreign key → COMMUNITY_BOARD.PEOPLE_ID — NOT NULL
- FILE_NAME (파일명) — varchar
- REAL_NAME (실제파일명) — varchar
- FILE_SIZE (파일크기) — long
- FILE_LOCATE (파일경로) — varchar
MEETUP (오프라인모임)
- ID (오프모임키) — long — Primary key — NOT NULL
- MOIM_ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → MOIM.PEOPLE_ID — NOT NULL
- TITLE (제목) — VARCHAR
- MEET_DATE (모임날짜) — VARCAHR
- DETAIL_ADDRESS (전체주소) — long
- LOCATION_X (X좌표) — double
- LOCATION_Y (Y좌표) — double
- MONEY (참가비용) — int
- PEOPLE_LIMIT (인원제한) — int
- CREATE_DATE (생성일자) — Date
MEETUP_PEOPLE (오프라인모임참여자)
- ID (key) — long — Primary key — NOT NULL
- MEETUP_NO (오프모임키) — long — Foreign key → MEETUP.ID — NOT NULL
- ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → MOIM.PEOPLE_ID — NOT NULL
- CREATE_TIME (참여일자) — DATETIME
- JOIN_CANCLE (참여취소여부) — CHAR
MENU (메뉴명)
- ID (키값) — long — Primary key — NOT NULL
- MENU_NAME (메뉴명) — varchar
- MENU_URL (메뉴_URL) — varchar
- MENU_MEMO (메뉴_내용) — varchar
- MENU_GB (메뉴구분) — varchar
- MENU_ORDER (순서) — long
- DEL_YN (삭제여부) — varchar
- CREATED_DATE (작성일자) — DateTime
- UPDATE_DATE (수정일자) — DateTime
- CREATED_USER (등록자) — varcahr
- UPDATED_USER (수정자) — varchar
MOIM (모임)
- ID (모임번호) — long — Primary key — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
- CATEGORY (모임주제분류) — varchar
- TITLE (모임제목) — varchar
- INTRO (모임소개글) — varchar
- PEOPLE_LIMIT (모임인원수제한) — long
- CREATE_DATE (모임생성일자) — Date
- UPDATE_DATE (모임업데이트일자) — Date
- CITY_CODE1 (도시코드) — varchar
- AREA_CODE1 (지역코드1) — vachar
- JOIN_CONDITION (가입조건) — CHAR
- SECRET_CONDITION (공개/비공개)
- RECRUIT_STATUS (모집상태) — VARCHAR
- HASH_TAG (해시태그) — VARCHAR
- Field
MOIM_BOARD (모임내게시판전용)
- ID (글번호) — long — Primary key — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
- BOARD_GROUP_ID (게시판 그룹번호) — long — Foreign key → BOARD_GROUP.ID — NOT NULL
- ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- ID (순번) — long — Foreign key → MOIM_TODO_WRITE_LIST.ID — NOT NULL
- ID (번호2) — long — Foreign key → MOIM_TODO_WRITE_LIST.ID — NOT NULL
- TITLE (제목) — varchar
- MEMO (설명) — varchar
- CREATE_DATE (최초작성일자) — DateTime
- UPDATE_DATE (수정일자) — DateTime
- DELETE_FLAG (삭제여부) — char
- HEART (좋아요수) — long
- REPRESENT_IMAGE (Field)
- IP_ADDR (아이피주소) — varchar
MOIM_BOARD_FILE (모임내게시판자료)
- Key — Primary key — NOT NULL
- ID (글번호) — long — Foreign key → MOIM_BOARD.ID — NOT NULL
- ID (순번2) — long — Foreign key → MOIM_BOARD.ID — NOT NULL
- ID (번호2) — long — Foreign key → MOIM_BOARD.ID — NOT NULL
- FILE_NAME (파일명) — varchar
- REAL_NAME (실제파일명) — varchar
- FILE_SIZE (파일크기) — long
- FILE_LOCATE (파일경로) — varchar
- REPRESENT_IMAGE (순번) — long
MOIM_PEOPLE (모임참여자)
- MOIM_ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
- ROLE (모임에서역할) — varchar
- JOIN_DATE (참여일자) — DATETIME
- BAN_YN (강퇴여부) — char
- JOIN_CONDITION (가입승인대기) — char
MOIM_TODO_WRITE (모임일정계획세우는테이블)
- ID (번호) — long — Primary key — NOT NULL
- ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → MOIM.PEOPLE_ID — NOT NULL
- PLAN_TITLE (계획제목) — varchar
- FROM_DATE (시작일) — DATETIME
- TO_DATE (종료일) — DATETIME
- CREATED_DATE (최초작성일) — DATETIME
- PROGRESS_DONE (진행량) — long
- PROGRESS_TOTAL (전체계획량) — long
- PROGRESS (진행퍼센트) — long
- STATUS (진행상태) — varchar
- TO_DATE2 (추가날짜) — DATETIME
MOIM_TODO_WRITE_LIST (모임일정계획리스트)
- ID (순번) — long — Primary key — NOT NULL
- ID (번호) — long — Foreign key → MOIM_TODO_WRITE.ID — NOT NULL
- ID (모임번호) — long — Foreign key → MOIM_TODO_WRITE.ID — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → MOIM_TODO_WRITE.PEOPLE_ID — NOT NULL
- PLAN_LIST (계획리스트) — varchar
- CHECK_CONFRIM (계획체크) — CHAR
MoimChat (채팅방)
- ID (채팅번호) — Primary key — NOT NULL
- ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → MOIM.PEOPLE_ID — NOT NULL
- CHATMEMO (채팅내용) — String
NOTI (알림)
- ID (번호) — LONG — Primary key — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
- ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- MEMO (내용) — VARCHAR
- CREATED_DATE (보낸날짜) — DATE
- APP_YN (승인여부) — VARCHAR
- CLOSE_YN (알림끄기여부) — CHAR
- GUBUN_CD (개인/모임구분) — CHAR
- READ_YN (알림본거여부) — CHAR
PEOPLE (유저)
- ID (사용자번호) — long — Primary key — NOT NULL
- PEOPLEID (아이디) — varchar
- PASSWORD (비밀번호) — varchar
- NICKNAME (사용자이름) — varchar
- CREATE_TIME (등록일자) — DATETIME
- UPDATE_TIME (수정일자) — DATETIME
- IMAGE_PATH (이미지경로) — VARCHAR
- IMAGE_NAME (이미지이름) — VARCHAR
- IMAGE_EXTENSION (Field) — VARCHAR
- USE_YN (사용유무) — VARCHAR
- EMAIL_YN (이메일인증여부) — CHAR
- EMAIL (이메일) — VARCHAR
- JOB (직업) — VARCHAR
- CATEGORY (관심사(주제)) — VARCHAR
- SEX (성별) — VARCHAR
- INTRODUCE (자기소개) — VARCHAR
- BIRTHDAY (생년월일) — DATETIME
ROLE (유저롤)
- ID (순번) — LONG — Primary key — NOT NULL
- NAME (권한이름) — VARCHAR
USER_HISTORY (유저 기록)
- ID (Key) — Primary key — NOT NULL
- PEOPLE_ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
- LOGIN_DATE (접속일자) — DATETIME
- OS_TYPE (OS타입) — VARCHAR
- ACCESS_NAME (접근유저) — VARCHAR
- CREATE_TIME (등록날짜) — DATETIME
- ACCESS_PATH (접근경로) — VARCHAR
- IPADRESS (IP주소) — varchar
- SESSION_LASTACCESS (마지막접근시간) — varchar
USER_ROLES (커넥터)
- ID (순번) — LONG — Foreign key → ROLE.ID — NOT NULL
- ID (사용자번호) — long — Foreign key → PEOPLE.ID — NOT NULL
VISITOR_CHECK (방문자)
- ID (기본키) — long — Primary key — NOT NULL
- VISIT_IP (방문자IP) — VARCHAR
- VISIT_TIME (접속시간) — DATETIME
- VISIT_ACCESS (접속경로) — VARCHAR
- VISIT_AGENT (접속브라우저) — VARCHAR
- VISIT_REFER (어디경로타고왔는지) — VARCHAR
moim_tag (Untitled)
- ID (모임번호) — long — Foreign key → MOIM.ID — NOT NULL
- id (태그키) — long — Foreign key → tag.id — NOT NULL
tag (해시태그)
- id (태그키) — long — Primary key — NOT NULL
- name (해시태그) — varchar