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