Skip to content

Instantly share code, notes, and snippets.

@k1LoW
Created August 8, 2018 13:25
Show Gist options
  • Save k1LoW/fa6ad575935b87c9e28061201666b4ac to your computer and use it in GitHub Desktop.
Save k1LoW/fa6ad575935b87c9e28061201666b4ac to your computer and use it in GitHub Desktop.
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
);
[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
$ sqlite3 test.db < 0_test.sql
$ mkdir tmp
$ tbls doc sq://`pwd`/test.db -f tmp/ --add 1_add.yml

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

er


Generated by tbls

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment