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 — 음원 길이