nakwon bible

Tables (5)

BIBLE_VERSIONS

  • version_id (Key) — INTEGER — Primary key — NOT NULL
  • version_code — TEXT — NOT NULL
  • version_name_ko — TEXT
  • version_name_en — TEXT
  • language — TEXT — NOT NULL
  • is_default — BOOLEAN
  • is_installed — BOOLEAN
  • display_order — INTEGER
  • installed_at — TIMESTAMP
  • updated_at — TIMESTAMP

appendix (appendix (부록))

  • id — integer — Primary key — NOT NULL — ID
  • Field (category) — text — 송영
  • Field (name) — text — 제목(예: 만복의근원하나님)
  • Field (chapter_origin) — text — 1장
  • Field (chapter) — integer — 장
  • Field (verse) — integer — 절
  • Field (content) — text — lyric
  • Field (image_url) — text — 찬송가 이미지 URL
  • Field (remark) — text — 비고
  • Field (file_url) — text — 음원 URL
  • Field (duration) — integer — 음원 길이

bible_details (bible_details (성경상세))

  • id — integer — Primary key — NOT NULL — 성경 상세 ID
  • id (bible_id) — integer — Foreign key → bibles.id — NOT NULL — 성경 ID
  • Field (code) — integer — 권 (1 : 창세기, 2 : 추애굽기...)
  • Field (name) — text — 한글명칭(창세기)
  • Field (chapter) — integer — 장
  • Field (verse) — integer — 절
  • Field (content) — text — 구절
  • Field (version) — text — 버전(개역개정, NIV)

bibles (bibles (성경))

  • id — integer — Primary key — NOT NULL — header ID
  • Field (code) — integer — 권 (1 : 창세기, 2 : 추애굽기...)
  • Field (end_chapter) — integer — 성경 장 수 (창세기 : 50)
  • Field (name) — text — 한글명칭 (창세기)
  • Field (name_short) — text — 할글명칭 단축 (창)
  • Field (name_en) — text — 영어명칭 (Genesis)
  • Field (name_en_short) — text — 영어명칭 단축 (Gen)
  • Field (version) — text — 버전(개역개정, NIV)
  • Field (file_url) — text — 음원 URL
  • Field2 (duration) — integer — 음원 길이

hymns (hymns (찬송가))

  • id — integer — Primary key — NOT NULL — ID
  • Field (category) — text — 송영
  • Field (name) — text — 제목(예: 만복의근원하나님)
  • Field (chapter_origin) — text — 1장
  • Field (chapter) — integer — 장
  • Field (verse) — integer — 절
  • Field (lylic) — text — 가사
  • Field (image_url) — text — 찬송가 이미지 URL
  • Field (remark) — text — 비고
  • Field (file_url) — text — 음원 URL
  • Field (duration) — integer — 음원 길이