CLOUD BETA TEST

Tables (15)

app_content_apk

  • apkId — BIGINT(20) — Primary key — NOT NULL
  • appSizeInt — int(11) — NOT NULL
  • appSizeText — VARCHAR(40) — NOT NULL
  • filePath — TEXT — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • realname — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • contentId — BIGINT(20) — Foreign key → app_contents.contentId — NOT NULL

app_content_codes

  • c_codeId — BIGINT(20) — Primary key — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • hexcolors — VARCHAR(255) — NOT NULL

app_content_images

  • imageId — BIGINT(20) — Primary key — NOT NULL
  • imagePath — TEXT — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • imageType — ENUM('0', '1', '2') — NOT NULL — 0: Screenshots, 1: Thumbnails, 2: mainImages
  • order — INT(11)
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • contentId — BIGINT(20) — Foreign key → app_contents.contentId — NOT NULL

app_content_reviews

  • reviewId — BIGINT(20) — Primary key — NOT NULL
  • contentId — BIGINT(20) — Foreign key → app_contents.contentId — NOT NULL
  • text — TEXT — NOT NULL
  • deleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • mb_no — int(11) — Foreign key → g5_member.mb_no — NOT NULL

app_content_tester

  • testerId — BIGINT(20) — Primary key — NOT NULL
  • contentId — BIGINT(20) — Foreign key → app_contents.contentId — NOT NULL
  • mb_no — int(11) — Foreign key → g5_member.mb_no — NOT NULL
  • accepted — ENUM('READY', 'COMPLETE', 'REJECT') — NOT NULL — 테스터 심사상태
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

app_contents

  • contentId — BIGINT(20) — Primary key — NOT NULL
  • type — ENUM('RESERV', 'TESTING') — NOT NULL — 사전예약 / 테스팅
  • title — VARCHAR(255) — NOT NULL — 앱 제목
  • maker — VARCHAR(50) — NOT NULL — 앱 제작사
  • category — VARCHAR(100) — NOT NULL — 앱 분류
  • grade — ENUM('ALL', 'TWELVE', 'FIFTEEN', 'EIGHTEEN') — NOT NULL — 앱 연령 등급
  • description — TEXT — NOT NULL — 앱 설명
  • content — MEDIUMTEXT — NOT NULL — 앱 내용
  • companyEmail — VARCHAR(255) — 회사 문의 이메일
  • mainVideoUrl — TEXT — 메인 비디오 링크
  • surveyLink — TEXT — 설문조사 링크
  • storeLink — TEXT — 스토어 링크
  • recruitAmount — INT(1) — 모집 인원
  • testingDate — DATETIME — 테스트 마감 일
  • surveyDate — DATETIME — 설문 마감 일
  • launchDate — DATETIME — NOT NULL — 앱 런칭 일
  • launchStatus — ENUM('READY', 'TESTING', 'SURVEY', 'DONE') — NOT NULL — 앱 런칭상태
  • reviewStatus — ENUM('READY', 'REVIEW', 'COMPLETE', 'REJECT') — NOT NULL — 앱 등록심사 상태
  • deleted — TINYINT(1) — NOT NULL — 삭제 여부
  • createdAt — DATETIME — NOT NULL — 작성일
  • updatedAt — DATETIME — 수정일
  • deletedAt — DATETIME — 삭제일
  • mb_no — int(11) — Foreign key → g5_member.mb_no — NOT NULL

app_faqs

  • faqId — BIGINT(20) — Primary key — NOT NULL
  • question — TEXT — NOT NULL
  • answer — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

app_notice_images

  • imageId — BIGINT(20) — Primary key — NOT NULL
  • imagePath — TEXT — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • noticeId — BIGINT(20) — Foreign key → app_notices.noticeId — NOT NULL

app_notices

  • noticeId — BIGINT(20) — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • deleted — TINYINT(1) — NOT NULL
  • category — ENUM('NOTICE','EVENT','UPDATE') — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME

app_push_token

  • mb_no — int(11) — Foreign key → g5_member.mb_no — NOT NULL
  • fcmToken — TEXT — FCM 토큰
  • receivYN — TINYINT(1) — NOT NULL — 수신동의
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

app_qnas

  • qnaId — BIGINT(20) — Primary key — NOT NULL
  • title — TEXT — NOT NULL
  • question — TEXT — NOT NULL
  • questionDate — DATETIME — NOT NULL
  • answer — TEXT
  • answerDate — DATETIME
  • completed — ENUM('WAIT','DONE') — NOT NULL
  • deleted — TINYINT(1) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL
  • deletedAt — DATETIME
  • mb_no — int(11) — Foreign key → g5_member.mb_no — NOT NULL

app_rewards

  • rewardId — BIGINT(20) — Primary key — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • code — VARCHAR(255) — NOT NULL
  • expired — TINYINT(1) — NOT NULL
  • expDate — DATETIME — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

app_user_reserved

  • u_reservId — BIGINT(20) — Primary key — NOT NULL
  • contentId — BIGINT(20) — Foreign key → app_contents.contentId — NOT NULL
  • mb_no — int(11) — Foreign key → g5_member.mb_no — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

app_user_rewards

  • u_rewardId — BIGINT(20) — Primary key — NOT NULL
  • rewardId — BIGINT(20) — Foreign key → app_rewards.rewardId — NOT NULL
  • mb_no — int(11) — Foreign key → g5_member.mb_no — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

g5_member

  • mb_no — int(11) — Primary key — NOT NULL
  • mb_id — varchar(255) — NOT NULL
  • mb_sn — varchar(255) — NOT NULL
  • mb_password — varchar(255) — NOT NULL
  • mb_name — varchar(255) — NOT NULL
  • mb_nick — varchar(255) — NOT NULL
  • mb_nick_date — date — NOT NULL
  • mb_email — varchar(255) — NOT NULL
  • mb_homepage — varchar(255) — NOT NULL
  • mb_level — tinyint(4) — NOT NULL
  • mb_sex — char(1) — NOT NULL
  • mb_birth — varchar(255) — NOT NULL
  • mb_tel — varchar(255) — NOT NULL
  • mb_hp — varchar(255) — NOT NULL
  • mb_certify — varchar(20) — NOT NULL
  • mb_adult — tinyint(4) — NOT NULL
  • mb_dupinfo — varchar(255) — NOT NULL
  • mb_zip1 — char(3) — NOT NULL
  • mb_zip2 — char(3) — NOT NULL
  • mb_addr1 — varchar(255) — NOT NULL
  • mb_addr2 — varchar(255) — NOT NULL
  • mb_addr3 — varchar(255) — NOT NULL
  • mb_addr_jibeon — varchar(255) — NOT NULL
  • mb_signature — text — NOT NULL
  • mb_recommend — varchar(255) — NOT NULL
  • mb_point — int(11) — NOT NULL
  • mb_today_login — datetime — NOT NULL
  • mb_login_ip — varchar(255) — NOT NULL
  • mb_datetime — datetime — NOT NULL
  • mb_ip — varchar(255) — NOT NULL
  • mb_leave_date — varchar(8) — NOT NULL
  • mb_intercept_date — varchar(8) — NOT NULL
  • mb_email_certify — datetime — NOT NULL
  • mb_email_certify2 — varchar(255) — NOT NULL
  • mb_memo — text — NOT NULL
  • mb_lost_certify — varchar(255) — NOT NULL
  • mb_mailling — tinyint(4) — NOT NULL
  • mb_sms — tinyint(4) — NOT NULL
  • mb_open — tinyint(4) — NOT NULL
  • mb_open_date — date — NOT NULL
  • mb_profile — text — NOT NULL
  • mb_memo_call — varchar(255) — NOT NULL
  • mb_1 — varchar(255) — NOT NULL
  • mb_2 — varchar(255) — NOT NULL
  • mb_3 — varchar(255) — NOT NULL
  • mb_4 — varchar(255) — NOT NULL
  • mb_5 — varchar(255) — NOT NULL
  • mb_6 — varchar(255) — NOT NULL
  • mb_7 — varchar(255) — NOT NULL
  • mb_8 — varchar(255) — NOT NULL
  • mb_9 — varchar(255) — NOT NULL
  • mb_10 — varchar(255) — NOT NULL
  • as_msg — tinyint(4) — NOT NULL
  • as_photo — tinyint(4) — NOT NULL
  • as_partner — tinyint(4) — NOT NULL
  • as_marketer — tinyint(4) — NOT NULL
  • as_exp — int(11) — NOT NULL
  • as_level — int(11) — NOT NULL
  • as_like — int(11) — NOT NULL
  • as_liked — int(11) — NOT NULL
  • … +7