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