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