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