0_test.sql

CREATE TABLE a (
  order_no TEXT NOT NULL,
  detail_no TEXT NOT NULL,
  amazon_item_id TEXT NOT NULL,
  divided_delivery_charge TEXT NOT NULL,
  divided_cod_fee TEXT NOT NULL,
  registration_date TEXT NOT NULL,
  registration_id TEXT NOT NULL,
  update_date TEXT NOT NULL,
  update_id TEXT NOT NULL
);

CREATE TABLE b (
  order_no TEXT NOT NULL,
  store_code TEXT NOT NULL,
  course TEXT NOT NULL,
  registration_date TEXT NOT NULL,
  registration_id TEXT NOT NULL,
  update_date TEXT NOT NULL,
  update_id TEXT NOT NULL
);

1_add.yml

[0] 0:zsh*                                                                                                                                                                  "101000LAB.local" 23:32 24- 7-18
comments:
    -
        table: a
        tableComment: xxxxxxxxxxxxxxxxxxxxx
        columnComments:
            order_no: xxxxxxxx
            detail_no: xxxxxxxxx
            amazon_item_id: xxxxxxxx
            divided_delivery_charge: xxxxxxxxx
            divided_cod_fee: xxxxxxxxx
            registration_date: xxxxxxxxx
            registration_id: xxxxxxxxx
            update_date: xxxxxxxxx
            update_id: xxxxxxxxx
    -
        table: b
        tableComment: xxxxxxxxx
        columnComments:
            order_no: xxxxxxxxx
            store_code: xxxxxxxxx
            course: xxxxxxxxx
            registration_date: xxxxxxxxx
            registration_id: xxxxxxxxx
            update_date: xxxxxxxxx
            update_id: xxxxxxxxx

2_command.console

$ sqlite3 test.db < 0_test.sql
$ mkdir tmp
$ tbls doc sq://`pwd`/test.db -f tmp/ --add 1_add.yml

3_a.md

a

Description

xxxxxxxxxxxxxxxxxxxxx

Table Definition

CREATE TABLE a (
  order_no TEXT NOT NULL,
  detail_no TEXT NOT NULL,
  amazon_item_id TEXT NOT NULL,
  divided_delivery_charge TEXT NOT NULL,
  divided_cod_fee TEXT NOT NULL,
  registration_date TEXT NOT NULL,
  registration_id TEXT NOT NULL,
  update_date TEXT NOT NULL,
  update_id TEXT NOT NULL
)

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
order_no	TEXT		false			xxxxxxxx
detail_no	TEXT		false			xxxxxxxxx
amazon_item_id	TEXT		false			xxxxxxxx
divided_delivery_charge	TEXT		false			xxxxxxxxx
divided_cod_fee	TEXT		false			xxxxxxxxx
registration_date	TEXT		false			xxxxxxxxx
registration_id	TEXT		false			xxxxxxxxx
update_date	TEXT		false			xxxxxxxxx
update_id	TEXT		false			xxxxxxxxx

Relations

---

Generated by tbls