munaro

Tables (11)

MISSION_SUBMISSIONS (미션)

  • MISSION_ID (Key) — bigserial — Primary key — NOT NULL
  • SUBMISSION_TYPE (Field) — ENUM('QUIZ', 'PHOTO')
  • STATUS (Field2) — ENUM('PASSED','FAILED','SKIPPED')
  • SCORE_AWARDED (Field3) — INTEGER
  • PAYLOAD (Field4) — JSONB
  • SUBMITTED_AT (Field5) — timestampz

PHOTO_MISSIONS (사진 미션)

  • PHOTO_MISSION_ID (Key) — int — Primary key — NOT NULL
  • MISSION_ID (Key2) — int — Foreign key → MISSION_SUBMISSIONS.MISSION_ID — NOT NULL
  • GUIDE_TEXT (Field) — TEXT
  • SAMPLE_IMAGE_URL (Field2) — varchar(500)
  • IS_ACTIVE (Field5) — BOOLEAN

PROFILES (프로필)

  • PROFILE_ID (Key) — bigint — Primary key — NOT NULL
  • USER_ID (Key2) — bigserial — Foreign key → USERS.USER_ID — NOT NULL
  • NICKNAME (Field) — varchar(20)
  • AVATAR_TYPE (Field2) — ENUM('PRESET','UPLOADED')
  • AVARTAR_VALUE (Field3) — varchar(500)
  • UPDATED_AT (Field4) — timestamptz

QUIZZES (퀴즈)

  • QUIZ_ID (Key) — bigserial — Primary key — NOT NULL
  • TITLE (Field) — VARCHAR(120)
  • DIFFICULTY (Field2) — ENUM('EASY','NORMAL','HARD')
  • DISPLAY_ORDER (Field3) — integer
  • IS_ACTIVE (Field4) — BOOLEAN
  • CREATED_AT (Field5) — timestampz

QUIZ_CHOICES (퀴즈옵션)

  • QUIZ_CHOICE_ID (Key) — bigserial — Primary key — NOT NULL
  • LABEL (Field) — varchar(2)
  • CONTENT (Field2) — TEXT
  • IS_CORRECT (Field3) — BOOLEAN

QUIZ_QUESTIONS (퀴즈 질문)

  • QUESTION_ID (Key) — bigserial — Primary key — NOT NULL
  • ORDINAL (Field) — integer
  • STEM (Field2) — TEXT
  • EXPLANATION (Field3) — TEXT
  • SCORE (Field4) — INTEGER

RANKINGS (Untitled)

  • RANKING_ID (Key) — int — Primary key — NOT NULL
  • TOTAL_STAMPS (Field) — int
  • CURRENT_RANK (Field2) — int
  • BEST_RANK (Field3) — int
  • TOP10_COUNT (Field4) — int
  • UPDATED_AT (Field5) — datetime

STAMPS (스탬프)

  • STAMP_ID (Key) — int — Primary key — NOT NULL
  • ACQUIRED_AT (Field) — datetime

TOURIST_SPOTS (장소)

  • SPOT_ID (Key) — bigserial — Primary key — NOT NULL
  • NAME (Field) — varchar(100)
  • CATEGORY (Field2) — ENUM('HERITAGE', 'MUSEUM', 'NATURE', 'TRADITIONAL_MARKET', 'TEMPLE', 'ETC')
  • DESCRIPTION (Field3) — TEXT
  • LATITUDE (Field6) — DECIMAL(10,7)
  • LONGITUDE (Field7) — DECIMAL(10,7)
  • ADDRESS (Field4) — varchar(255)
  • THUMBNAIL_URL (Field5) — varchar(500)
  • IS_ACTIVE (Field8) — BOOLEAN
  • CREATED_AT (Field9) — timestampz

USERS (사용자)

  • USER_ID (Key) — bigserial — Primary key — NOT NULL
  • EMAIL (Field) — varchar(255)
  • AUTH_PROVIDER (Field7) — ENUM('KAKAO','GOOGLE','EMAIL')
  • PROVIDER_USER_ID (Field3) — varchar(255)
  • PASSWORD_HASH (Field2) — varchar(255)
  • ROLE (Field4) — ENUM('USER','ADMIN')
  • STATUS (Field5) — ENUM('ACTIVE','SUSPENDED','DELETED')
  • CREATED_AT (Field6) — timestampz
  • LAST_LOGIN_AT (Field8) — timestampz

USER_MISSION_PROGRESS (유저 퀴즈 진도 현황)

  • PROGRESS_ID (Key) — int — Primary key — NOT NULL
  • STATUS (Field) — varchat(30)
  • SCORE (Field2) — int
  • VERIFIDE (Field3) — BOOLEAN
  • COMPLETED_AT (Field4) — datetime
  • MISSION_ID (Key3) — int — Foreign key → MISSION_SUBMISSIONS.MISSION_ID — NOT NULL
  • USER_ID (Key2) — UUID — Foreign key → USERS.USER_ID — NOT NULL