biblely-1.0.0
Tables (36)
admin_user (어드민 유저 관리 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (email) — VARCHAR(320) — Primary key — NOT NULL
- Index (authority_type) — CHAR(1) — Primary key — NOT NULL
- Key (song_calculate_administrator_uid) — CHAR(10) — Foreign key → song_calculate_administrator.Key — NOT NULL
- Field (password) — VARCHAR(32)
- Field (calculate_administrator_uid) — CHAR(10)
- Field (client_ip) — VARCHAR(40)
- Field (activation) — CHAR(1)
- Field (login_updated) — DATETIME
- Field (update) — DATETIME
- Field (create) — DATETIME
admin_user_history (어드민 유저 히스토리 테이블)
- Key (num) — autoIncrement — Primary key — NOT NULL
- Index (email) — VARCHAR(320) — Primary key — NOT NULL
- Index (method) — VARCHAR(6) — Primary key — NOT NULL
- Field (content) — VARCHAR(128)
- Field (created) — DATETIME
album (앨범 목록 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (artist_uid) — CHAR(10) — Primary key — NOT NULL
- Index (album_type) — VARCHAR(10) — Primary key — NOT NULL
- Index (sub_album_type) — VARCHAR(10) — Primary key — NOT NULL
- Index (image_uid) — CHAR(10) — Primary key — NOT NULL
- Key (artist_uid2) — CHAR(10) — Foreign key → artist.Key — NOT NULL
- Field (title) — VARCHAR(100) — NOT NULL
- Field (product) — CHAR(1)
- Field (like_count) — UNSIGNED INT
- Field (activation) — CHAR(1)
- Field (releaseDate) — DATETIME
- Field (detail) — VARCHAR(1024)
- Field (peruse_start_date) — DATETIME
- Field (persuse_end_date) — DATETIME
- Field (distributor_album_code) — VARCHAR(20)
- Field (updated) — DATETIME
- Field (created) — DATETIME
app_version (플랫폼 별 앱버전)
- Key (platform) — VARCHAR(10) — Primary key — NOT NULL
- Key (version_type) — CHAR(1) — Primary key — NOT NULL
- Field (version) — VARCHAR(10)
- Field (updator) — VARCHAR(256)
- Field (app_url) — VARCHAR(256)
- Field (comment) — VARCHAR(40)
- Field (updated) — DATETIME
- Field (created) — DATETIME
artist (아티스트 목록 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (name) — VARCHAR(30) — Primary key — NOT NULL
- Index (image_uid) — CHAR(10) — Primary key
- Index (church_uid) — CHAR(10) — Primary key — NOT NULL
- Key (church_uid2) — CHAR(10) — Foreign key → church.Key — NOT NULL
- Field (activity_type) — CHAR(1)
- Field (job_type) — VARCHAR(10)
- Field (audio_url) — VARCHAR(256)
- Field (chuch_updated) — DATETIME
- Field (main_pastor) — CHAR(1)
- Field (activation) — CHAR(1)
- Field (like_count) — UNSIGNED INT
- Field (expose_order) — UNSIGNED INT
- Field (detail) — VARCHAR(1024)
- Field (updated) — DATETIME
- Field (created) — DATETIME
badword_dictionary (금칙어 사전)
- Key (num) — autoIncrement — Primary key — NOT NULL
- Index (use_yn) — CHAR(1) — Primary key — NOT NULL
- Field (badword) — VARCHAR(50)
- Field (created) — DATETIME
banner (배너 목록 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (image_uid) — CHAR(10) — Primary key
- Field (type) — CHAR(1)
- Field (title) — VARCHAR(256)
- Field (start_expose) — DATETIME
- Field (end_expose) — DATETIME
- Field (target_type) — CHAR(1)
- Field (target_url) — VARCHAR(256)
- Field (expose_order) — UNSIGNED INT
- Field (updated) — DATETIME
- Field (created) — DATETIME
bible_album (성경 앨범 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (artist_uid) — CHAR(10) — Primary key — NOT NULL
- Index (bible_version_uid) — CHAR(10) — Primary key — NOT NULL
- Key (aritist_uid2) — CHAR(10) — Foreign key → artist.Key — NOT NULL
- Key (bible_version_uid2) — CHAR(10) — Foreign key → bible_version.Key — NOT NULL
- Field (product) — CHAR(1)
- Field (activation) — CHAR(1)
- Field (album_hash) — UNSIGNED INT
- Field (detail) — VARCHAR(1024)
- Field (updated) — DATETIME
- Field (created) — DATETIME
bible_alias (성경 권(목차) 목록 테이블)
- Key (bible_version_uid) — CHAR(10) — Primary key — NOT NULL
- Key (book) — UNSIGNED INT — Primary key — NOT NULL
- Key (bible_version_uid2) — CHAR(10) — Foreign key → bible_version.Key — NOT NULL
- Field (book_code) — VARCHAR(10)
- Field (book_name) — VARCHAR(20)
- Field (chapter_count) — UNSIGNED INT
- Field (updated) — DATETIME
- Field (created) — DATETIME
bible_translate (성경 버전(역본)별 음원 관리 테이블)
- Key (book) — UNSIGNED INT — Primary key — NOT NULL
- Key (chapter) — UNSIGNED INT — Primary key — NOT NULL
- Key (bible_album_uid) — CHAR(10) — Primary key — NOT NULL
- Key (bible_album_uid2) — CHAR(10) — Foreign key → bible_album.Key — NOT NULL
- Index (artist_uid) — CHAR(10) — Foreign key → bible_album.Index — NOT NULL
- Field (source_file_url) — VARCHAR(256)
- Field (source_file_play_length) — INT
- Field (lrc_file_url) — VARCHAR(256)
- Field (updated) — DATETIME
- Field (created) — DATETIME
bible_user (성경 회원 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (email) — VARCHAR(320) — Primary key — NOT NULL
- Index (social) — VARCHAR(10) — Primary key — NOT NULL
- Field (nickname) — CHAR(20)
- Field (nicknameUpdated) — DATETIME
- Field (player_id) — VARCHAR(40)
- Field (platform) — VARCHAR(10)
- Field (platform_version) — VARCHAR(10)
- Field (carrier) — VARCHAR(20)
- Field (payment_status) — CHAR(1)
- Field (terms_use) — CHAR(1)
- Field (subscribe_code) — CHAR(2)
- Field (marketing_agree) — CHAR(1)
- Field (marketing_updated) — DATETIME
- Field (login_status) — CHAR(1)
- Field (login_updated) — DATETIME
- Field (user_status) — CHAR(1)
- Field (user_updated) — DATETIME
- Field (created) — DATETIME
bible_user_addition (회원 추가 정보)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (church_uid) — CHAR(10) — Primary key — NOT NULL
- Key (bible_user_uid) — CHAR(10) — Foreign key → bible_user.Key — NOT NULL
- Field (updated) — DATETIME
- Field (created) — DATETIME
bible_user_cancel_reason (회원 탈퇴 사유)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (email) — VARCHAR(320) — Primary key — NOT NULL
- Key (bible_user_uid) — CHAR(10) — Foreign key → bible_user.Key — NOT NULL
- Field (cancel_reason) — VARCHAR(50)
- Field (created) — DATETIME
bible_user_like (성경 회원 좋아요 관리 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Key (content_type) — VARCHAR(10) — Primary key — NOT NULL
- Key (content_uid) — CHAR(10) — Primary key — NOT NULL
- Key (bible_user_uid) — CHAR(10) — Foreign key → bible_user.Key — NOT NULL
- Field (like) — CHAR(1)
- Field (updated) — DATETIME
- Field (created) — DATETIME
bible_user_peruse_subscribe (유저별 성경 통독 구독 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Key (bible_user_uid) — CHAR(10) — Primary key — NOT NULL
- Key (album_uid) — CHAR(10) — Primary key — NOT NULL
- Key (album_uid2) — CHAR(10) — Foreign key → album.Key — NOT NULL
- Field (subscribe_date) — DATETIME
- Field (subscribe_end_date) — DATETIME
- Field (created) — DATETIME
bible_user_peruse_subscribe_detail (유저별 성경 통독 구독 상세 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Key (song_uid) — CHAR(10) — Primary key — NOT NULL
- Key (subscribe_uid) — CHAR(10) — Foreign key → bible_user_peruse_subscribe.Key — NOT NULL
- Field (complete_status) — CHAR(1)
- Field (play_end_time) — DATETIME
- Field (created) — DATETIME
bible_user_read (유저별 성경 읽기표 테이블)
- Key (bible_user_uid) — CHAR(10) — Primary key — NOT NULL
- Key (book) — UNSIGNED INT — Primary key — NOT NULL
- Key (chapter) — UNSIGNED INT — Primary key — NOT NULL
- Key (bible_alias_book) — UNSIGNED INT — Foreign key → bible_alias.Key — NOT NULL
- Field (play_count) — UNSIGNED INT
- Field (play_end_time) — DATETIME
- Field (created) — DATETIME
bible_version (성경 버전(역본) 목록 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (language_uid) — CHAR(10) — Primary key — NOT NULL
- Key (language_uid2) — CHAR(10) — Foreign key → language.Key — NOT NULL
- Field (version_code) — VARCHAR(10)
- Field (version_name) — VARCHAR(100)
- Field (updated) — DATETIME
- Field (created) — DATETIME
church (교회 목록 관리 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Field (name) — VARCHAR(50)
- Field (address_type) — CHAR(1)
- Field (address) — VARCHAR(128)
- Field (activation) — CHAR(1)
- Field (expose_order) — UNSIGNED INT
- Field (updated) — DATETIME
- Field (created) — DATETIME
code_dictionary (코드 사전 테이블)
- Key (code) — VARCHAR(10) — Primary key — NOT NULL
- Key (type) — VARCHAR(10) — Primary key — NOT NULL
- Field (name) — VARCHAR(50)
image (이미지 관리 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Key (type) — CHAR(4) — Primary key — NOT NULL
- Index (image_uid) — CHAR(10) — Foreign key → artist.Index — NOT NULL
- Index (image_uid2) — CHAR(10) — Foreign key → album.Index — NOT NULL
- Index (image_uid3) — CHAR(10) — Foreign key → banner.Index
- Field (photo_url) — VARCHAR(1024)
- Field (update) — DATETIME
- Field (created) — DATETIME
language (언어 목록 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Field (type) — CHAR(3)
- Field (name) — VARCHAR(20)
- Field (direction) — CHAR(1)
- Field (updated) — DATETIME
- Field (created) — DATETIME
membership_billing_info (회원 결제 정보)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (ios_original_order_id) — VARCHAR(20) — Primary key — NOT NULL
- Index (aos_receipt_data) — VARCHAR(128) — Primary key — NOT NULL
- Field (email) — VARCHAR(320)
- Field (social) — VARCHAR(10)
- Field (platform) — VARCHAR(10)
- Field (product_id) — VARCHAR(128)
- Field (order_id) — VARCHAR(30)
- Field (price) — DECIMAL(8,3)
- Field (price_currency_code) — CHAR(3)
- Field (subscribe_status) — UNSIGNED INT
- Field (purchase_date) — DATETIME
- Field (latest_expired_date) — DATETIME
- Field (created) — DATETIME
membership_billing_notification_history (회원 결제 알림 히스트리)
- Key (num) — autoIncrement — Primary key — NOT NULL
- Index (uid) — CHAR(10) — Primary key — NOT NULL
- Index (ios_original_order_id) — VARCHAR(20) — Primary key — NOT NULL
- Index (aos_receipt_data) — VARCHAR(128) — Primary key — NOT NULL
- Key (billing_uid) — CHAR(10) — Foreign key → membership_billing_info.Key — NOT NULL
- Index (billing_ios_original_order_id) — VARCHAR(20) — Foreign key → membership_billing_info.Index — NOT NULL
- Index (billing_aos_receipt_data) — VARCHAR(128) — Foreign key → membership_billing_info.Index — NOT NULL
- Field (platform) — VARCHAR(10)
- Field (order_id) — VARCHAR(30)
- Field (subscribe_status) — UNSIGNED INT
- Field (purchase_date) — DATETIME
- Field (event_date) — DATETIME
- Field (created) — DATETIME
nickname_dictionary (닉네임 사전)
- Key (word) — CHAR(6) — Primary key — NOT NULL
- Index (type) — VARCHAR(5) — Primary key — NOT NULL
notice (게시판 목록 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (register_uid) — CHAR(10) — Primary key — NOT NULL
- Field (register_type) — CHAR(1)
- Field (notice_type) — CHAR(1)
- Field (title) — VARCHAR(100)
- Field (content) — TEXT
- Field (activation) — CHAR(1)
- Field (updated) — DATETIME
- Field (created) — DATETIME
play_statistic (재생 통계 테이블)
- Index (artist_uid) — CHAR(10) — Primary key — NOT NULL
- Index (album_uid) — CHAR(10) — Primary key — NOT NULL
- Index (song_uid) — CHAR(10) — Primary key — NOT NULL
- Index (artist_uid2) — CHAR(10) — Foreign key → play_statistic_month_master.Index — NOT NULL
- Field (album_type) — VARCHAR(10)
- Field (play_mark) — VARCHAR(512)
- Field (created) — DATETIME
play_statistic_month_master (매월 1일마다 이전 월 통계 데이터 처리)
- Index (artist_uid) — CHAR(10) — Primary key — NOT NULL
- Field (play_year) — TINYINT UNSIGNED
- Field (play_month) — TINYINT UNSIGNED
- Field (play_count) — UNSIGNED INT
- Field (created) — DATETIME
song (음원 파일 목록)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (album_uid) — CHAR(10) — Primary key — NOT NULL
- Index (artist_uid) — CHAR(10) — Primary key — NOT NULL
- Key (album_uid2) — CHAR(10) — Foreign key → album.Key — NOT NULL
- Field (track_num) — UNSIGNED INT
- Field (title) — VARCHAR(100)
- Field (cd_index) — UNSINGED INT
- Field (main_title) — CHAR(1)
- Field (source_file_url) — VARCHAR(256)
- Field (source_file_play_length) — INT
- Field (lrc_file_url) — VARCHAR(256)
- Field (play_count) — UNSIGNED INT
- Field (like_count) — UNSIGNED INT
- Field (activation) — CHAR(1)
- Field (expose_order) — UNSIGNED INT
- Field (peruse_bible_info) — VARCHAR(512)
- Field (distributor_track_code) — VARCHAR(20)
- Field (updated) — DATETIME
- Field (created) — DATETIME
song_calculate_administrator (음원 정산 관리사)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (name) — VARCHAR(40) — Primary key — NOT NULL
- Field (updated) — DATETIME
- Field (created) — DATETIME
song_calculate_administrator_rate (음원 정산 관리사 별 비율)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Key (code) — CHAR(3) — Primary key — NOT NULL
- Key (enroll_num) — UNSIGNED INT — Primary key — NOT NULL
- Key (song_calcuate_administrator_uid) — CHAR(10) — Foreign key → song_calculate_administrator.Key — NOT NULL
- Field (money_rate) — FLOAT
- Field (created) — DATETIME
song_calculate_license (음원 정산 라이센스 테이블)
- Key (song_uid) — CHAR(10) — Primary key — NOT NULL
- Key (code) — CHAR(3) — Primary key — NOT NULL
- Key (enroll_num) — UNSIGNED INT — Primary key — NOT NULL
- Index (calculate_administrator_uid) — CHAR(10) — Primary key — NOT NULL
- Index (money_rate_enroll_num) — UNSIGNED INT — Primary key — NOT NULL
- Key (song_uid2) — CHAR(10) — Foreign key → song.Key — NOT NULL
- Key (song_calculate_administrator_uid) — CHAR(10) — Foreign key → song_calculate_administrator.Key — NOT NULL
- Field (share_rate) — FLOAT
- Field (updated) — DATETIME
- Field (created) — DATETIME
song_calculate_monthly_history (음원 정산 월별 히스토리)
- Key (num) — autoIncrement — Primary key — NOT NULL
- Index (song_uid) — CHAR(10) — Primary key — NOT NULL
- Index (monthly_calculate_date) — DATETIME — Primary key — NOT NULL
- Key (song_song_uid) — CHAR(10) — Foreign key → song.Key — NOT NULL
- Field (distributor_album_code) — VARCHAR(20)
- Field (distributor_track_code) — VARCHAR(20)
- Field (artist_name) — VARCHAR(30)
- Field (album_title) — VARCHAR(100)
- Field (track_num) — UNSIGNED INT
- Field (track_title) — VARCHAR(100)
- Field (play_count) — UNSIGNED INT
- Field (song_calculate_amount) — FLOAT
- Field (created) — DATETIME
song_calculate_monthly_license_history (음원 정산 월별 라이센스 히스토리)
- Key (num) — autoIncrement — Primary key — NOT NULL
- Index (song_uid) — CHAR(10) — Primary key — NOT NULL
- Index (monthly_calculate_date) — DATETIME — Primary key — NOT NULL
- Index (code) — CHAR(3) — Primary key — NOT NULL
- Index (enroll_num) — UNSIGNED INT — Primary key — NOT NULL
- Index (calculate_administrator_uid) — CHAR(10) — Primary key — NOT NULL
- Index (money_rate_enroll_num) — UNSIGNED INT — Primary key — NOT NULL
- Index (song_uid2) — CHAR(10) — Foreign key → song_calculate_monthly_history.Index — NOT NULL
- Index (monthly_calculate_date2) — DATETIME — Foreign key → song_calculate_monthly_history.Index — NOT NULL
- Field (calculate_administrator_name) — VARCHAR(40)
- Field (money_rate) — FLOAT
- Field (share_rate) — FLOAT
- Field (song_calculate_amount) — FLOAT
- Field (calculate_completor) — VARCHAR(320)
- Field (calculate_completed) — DATATIME
- Field (created) — DATETIME
user_book_mark (유저 북마크 목록 테이블)
- Key (uid) — CHAR(10) — Primary key — NOT NULL
- Index (email) — VARCHAR(320) — Primary key — NOT NULL
- Index (email2) — VARCHAR(320) — Foreign key → bible_user.Index — NOT NULL
- Field (book_mark) — VARCHAR(512)
- Field (created) — DATETIME
user_play_history (유저별 재생 히스토리 테이블)
- Key (num) — autoIncrement — Primary key — NOT NULL
- Index (bible_user_uid) — CHAR(10) — Primary key — NOT NULL
- Index (audio_uid) — CHAR(10) — Primary key — NOT NULL
- Index (play_type) — CHAR(1) — Primary key — NOT NULL
- Field (play_mark) — VARCHAR(512)
- Field (created) — DATETIME