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