hidef ind
Tables (14)
common_code (공통코드 모음)
- code_id (PK) — INT — Primary key — NOT NULL
- code_type (코드종류)
- code_value (코드 값)
- code_desc (코드설명)
- created_at (생성일)
- updated_at (수정일)
day_rank (일일랭킹)
- rank_id (PK) — Primary key — NOT NULL
- member_id (PK2) — INT — Foreign key → member.member_id — NOT NULL
- rank (순위)
- point (하루 찾은 개수)
- date (Field)
event (이벤트 링크 포함)
- event_id (PK) — Primary key — NOT NULL
- title (제목)
- desc (내용)
- event_type (유형)
- link (이동 링크)
- start_date (시작일)
- end_date (종료일)
- created_at (생성일)
- updated_at (수정일)
member (회원)
- member_id (PK) — INT — Primary key — NOT NULL
- name (이름)
- email (이메일)
- status (상태)
- image (사진)
- created_at (생성일)
- updated_at (수정일)
member_find_qr (회원발견QR)
- find_id (PK) — Primary key — NOT NULL
- member_id (PK2) — INT — Foreign key → member.member_id — NOT NULL
- qr_id (PK3) — Foreign key → member_hide_qr.qr_id — NOT NULL
- created_at (생성일)
member_follow (회원팔로우)
- follow_id (PK) — Primary key — NOT NULL
- follower_id (팔로우한 회원 ID)
- followed_id (팔로우된 회원ID)
- created_at (생성일)
member_hide_qr (회원 생성QR)
- qr_id (PK) — Primary key — NOT NULL
- member_id (PK2) — INT — Foreign key → member.member_id — NOT NULL
- qr_name (장소이름)
- lat (위도)
- lon (경도)
- qr_code (qr데이터)
- status (상태)
- hint (힌트)
- created_at (생성일)
- updated_at (수정일)
member_hide_qr_image (회원생성QR 이미지 힌트)
- qr_image_id (PK) — Primary key — NOT NULL
- qr_id (PK2) — Foreign key → member_hide_qr.qr_id — NOT NULL
- image (Field)
- main_yn (대표이미지여부)
- created_at (생성일)
- updated_at (수정일)
member_qr_comment (회원찾은QR 댓글)
- comment_id (PK) — Primary key — NOT NULL
- member_id (PK3) — INT — Foreign key → member.member_id — NOT NULL
- qr_id (PK2) — Foreign key → member_hide_qr.qr_id — NOT NULL
- comment (댓글)
- status (댓글상태)
- image (이미지)
- created_at (생성일)
- updated_at (수정일)
member_star_qr (회원좋아요QR)
- star_id (PK) — Primary key — NOT NULL
- member_id (PK2) — INT — Foreign key → member.member_id — NOT NULL
- qr_id (PK3) — Foreign key → member_hide_qr.qr_id — NOT NULL
- created_at (Field)
notice (공지사항 (이벤트랑 합칠까?))
- notice_id (Key) — Primary key — NOT NULL
- title (제목)
- content (내용)
- notice_type (공지유형)
- created_at (생성일)
- updated_at (수정일)
policy (이용약관)
- policy_id (PK) — Primary key — NOT NULL
- policy_type (정책유형)
- title (제목)
- content (내용)
- created_at (생성일)
- updated_at (수정일)
qna (도움말)
- qna_id (PK) — Primary key — NOT NULL
- question (질문)
- answer (답변)
- created_at (생성일)
- updated_at (수정일)
report_qr (qr신고내역)
- report_id (PK) — Primary key — NOT NULL
- member_id (회원ID)
- report_type (유형)
- qr_comment_id (qr 또는 댓글 ID)
- reason (사유)
- created_at (생성일)