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 (생성일)