CatchReview

Tables (11)

ADMINISTRATOR (관리자)

  • ADMINISTRATOR_ID (아이디) — Bigint — Primary key — NOT NULL
  • USERNAME (이메일) — varchar(255)
  • NAME (이름) — varchar(255)
  • PASSWORD (패스워드) — varchar(255)
  • PASSWORD_FAILURE_COUNT (패스워드 틀린횟수) — Bigint
  • LAST_MODIFIED_PASSWORD_AT (마지막 비밀번호 변경일자) — datetime
  • STATUS (상태) — varchar(20)
  • EMAIL_VALID_CODE (이메일 인증코드) — varchar(255)
  • IS_EMAIL_VALID (이메일 인증여부) — char(1)
  • LAST_LOGIN_AT (마지막 로그인 날짜) — datetime
  • WITH_DRAW_AT (탈퇴 날짜) — datetime
  • CREATED_BY_ADMIN_ID (생성자 아이디) — Bigint
  • UPDATED_BY_ADMIN_ID (수정자 아이디) — Bigint
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime

AdministratorRole (관리자역할)

  • MEMBER_ROLE_ID (아이디) — Bigint — Primary key — NOT NULL
  • ADMINISTRATOR_ID (관리자아이디) — Bigint — Foreign key → ADMINISTRATOR.ADMINISTRATOR_ID — NOT NULL
  • ROLE_NAME (역할아이디) — varchar(255) — Foreign key → Role.NAME — NOT NULL
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime

DIARY (일기)

  • DIARY_ID (아이디) — Bigint — Primary key — NOT NULL
  • MARK_DETAIL_ID (마크상세아이디) — Bigint — Foreign key → MarkDetail.MARK_DETAIL_ID — NOT NULL
  • TITLE (제목) — varchar(255)
  • CONTENT (내용) — TEXT
  • SHOW_YN (전시여부) — char(1)
  • DELETE_YN (삭제여부) — char(1)
  • CREATED_BY_ADMIN_ID (생성관리자아이디) — Bigint
  • UPDATED_BY_ADMIN_ID (수정관리자아이디) — Bigint
  • CREATED_BY_MEMBER_ID (생성회원아이디) — Bigint
  • UPDATED_BY_MEMBER_ID (수정회원아이디) — Bigint
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime

MENU_ROLE (메뉴권한)

  • MENU_ID (메뉴아이디) — Bigint — Foreign key → Menu.MENU_ID — NOT NULL
  • NAME (권한이름) — varchar(255) — Foreign key → Role.NAME — NOT NULL

Mark (마크)

  • MARK_ID (아이디) — Bigint — Primary key — NOT NULL
  • COORDINATE_X (X좌표) — varchar(255)
  • COORDINATE_Y (Y좌표) — varchar(255)
  • POINT (포인트) — Bigint
  • START_DATE_TIME (시작일시) — datetime
  • END_DATE_TIME (종료일시) — datetime
  • PROMOTION_STATUS (프로모션상태) — varchar(20)
  • APPLY_STATUS (신청상태) — varchar(20)
  • PUBLISH_STATUS (공개상태) — varchar(20)
  • CREATED_BY_MEMBER_ID (생성회원아이디) — Bigint
  • DELETE_YN (삭제여부) — char(1)
  • SHOW_YN (전시여부) — char(1)
  • CREATED_BY_ADMIN_ID (생성관리자아이디) — Bigint
  • UPDATED_BY_MEMBER_ID (수정회원아이디) — Bigint
  • UPDATED_BY_ADMIN_ID (수정관리자아이디) — Bigint
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime

MarkDetail (마크 상세)

  • MARK_DETAIL_ID (아이디) — Bigint — Primary key — NOT NULL
  • MARK_ID (마크아이디) — Bigint — Foreign key → Mark.MARK_ID — NOT NULL
  • MARK_TYPE (타입) — varchar(20)
  • TITLE (제목) — varchar(255)
  • SHORT_DESCRIPTION (한줄설명) — varchar(255)
  • CONTENT (상세설명) — TEXT
  • BANNER_IMG (배너이미지) — varchar(1000)
  • ZIP_CODE (우편번호) — varchar(255)
  • ADDRESS (주소) — varchar(255)
  • ADDRESS_DETAIL (상세주소) — varchar(255)
  • NOTE (참고) — TEXT
  • DELETE_YN (삭제여부) — char(1)
  • SHOW_YN (전시여부) — char(1)
  • CREATED_BY_ADMIN_ID (생성관리자아이디) — Bigint
  • UPDATED_BY_ADMIN_ID (수정관리자아이디) — Bigint
  • CREATED_BY_MEMBER_ID (생성회원아이디) — Bigint
  • UPDATED_BY_MEMBER_ID (수정회원아이디) — Bigint
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime

Member (회원)

  • MEMBER_ID (아이디) — Bigint — Primary key — NOT NULL
  • USERNAME (이메일) — varchar(255)
  • PASSWORD (패스워드) — varchar(255)
  • PASSWORD_FAILURE_COUNT (패스워드 틀린횟수) — Bigint
  • LAST_MODIFIED_PASSWORD_AT (마지막 비밀번호 변경일자) — datetime
  • NICKNAME (닉네임) — varchar(255)
  • STATUS (상태) — varchar(20)
  • EMAIL_VALID_CODE (이메일 인증코드) — varchar(255)
  • IS_EMAIL_VALID (이메일 인증여부) — char(1)
  • JOINED_AT (가입날짜) — datetime
  • LAST_LOGIN_AT (마지막 로그인 날짜) — datetime
  • WITH_DRAW_AT (탈퇴 날짜) — datetime
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime
  • PRIVACY_AGREEMENT_AT (개인정보 동의 일시) — datetime
  • MARKETING_AGREEMENT_AT (마케팅 수신 동의 일시) — datetime

MemberRole (회원역할)

  • MEMBER_ROLE_ID (아이디) — Bigint — Primary key — NOT NULL
  • MEMBER_ID (회원아이디) — Bigint — Foreign key → Member.MEMBER_ID — NOT NULL
  • ROLE_NAME (역할아이디) — varchar(255) — Foreign key → Role.NAME — NOT NULL
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime

Menu (메뉴)

  • MENU_ID (메뉴아이디) — Bigint — Primary key — NOT NULL
  • NAME (메뉴명) — varchar(255)
  • URL — varchar(1000)
  • DISPLAY_YN (전시여부) — varchar(20)
  • DELETE_YN (삭제여부) — varchar(20)
  • ACTIVE_YN (활성화여부) — varchar(20)
  • ANT_MATCHER_TYPE (하위메뉴포함여부) — varchar(20)
  • SORT_ORDER (순서) — Bigint
  • MENU_TYPE (메뉴유형) — varchar(20)
  • PARENT_ID (부모메뉴아이디) — Bigint

REVIEW (리뷰)

  • REVIEW_ID (아이디) — Bigint — Primary key — NOT NULL
  • MARK_DETAIL_ID (마크상세아이디) — Bigint — Foreign key → MarkDetail.MARK_DETAIL_ID — NOT NULL
  • TITLE (제목) — varchar(255)
  • CONTENT (내용) — TEXT
  • SHOW_YN (전시여부) — char(1)
  • DELETE_YN (삭제여부) — char(1)
  • CREATED_BY_ADMIN_ID (생성관리자아이디) — Bigint
  • UPDATED_BY_ADMIN_ID (수정관리자아이디) — Bigint
  • CREATED_BY_MEMBER_ID (생성회원아이디) — Bigint
  • UPDATED_BY_MEMBER_ID (수정회원아이디) — Bigint
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime

Role (역할)

  • NAME (이름) — varchar(255) — Primary key — NOT NULL
  • DESCRIPTION (설명) — varchar(255)
  • SORT_ORDER (순서) — Bigint
  • CREATED_AT (생성일) — datetime
  • UPDATED_AT (수정일) — datetime