Created
March 23, 2013 08:29
-
-
Save audreyt/5227000 to your computer and use it in GitHub Desktop.
English column names for ly dump
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE ttsinterpellation ( | |
| -- ask-by | |
| "質詢人" text, | |
| -- ask-type | |
| "質詢性質" text, | |
| -- ask-gazette | |
| "質詢公報" text, | |
| -- reason | |
| "案由" text, | |
| -- replied | |
| "答復否" text, | |
| -- reply-gazette | |
| "答復公報" text, | |
| -- project-seq | |
| "專案編號" text, | |
| -- ask-date | |
| "質詢日期" text, | |
| -- reply-date | |
| "答復日期" text, | |
| -- system-seq | |
| "系統號" text, | |
| -- image | |
| "提案影像" text, | |
| -- category | |
| "類別" text, | |
| -- subject | |
| "主題" text, | |
| -- keywords | |
| "關鍵詞" text, | |
| -- reply-by | |
| "答復人" text | |
| ); | |
| -- | |
| -- Name: ttsmotions; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE ttsmotions ( | |
| -- system-seq | |
| "系統號" text, | |
| -- meeting-type | |
| "會議別" text, | |
| -- session | |
| "會期" text, | |
| -- date | |
| "日期" text, | |
| -- chair | |
| "主席" text, | |
| -- data-source | |
| "資料來源" text, | |
| -- meeting-name | |
| "會議名稱" text, | |
| -- motion-code | |
| "議案代碼" text, | |
| -- motion-type | |
| "案別" text, | |
| -- meeting-content | |
| "會議及提案內容" text, | |
| -- resolution | |
| "決議" text, | |
| -- motion-seq | |
| "提案編號" plv8x.json, | |
| -- subject | |
| "主題" text, | |
| -- appendix | |
| "附加詞" text, | |
| -- law-seq | |
| "法編號" text, | |
| -- law-name | |
| "法名稱" plv8x.json, | |
| -- progress | |
| "進度" text, | |
| -- proposed-by | |
| "提案機關" text, | |
| -- category | |
| "類別" text, | |
| -- image | |
| "提案影像" text, | |
| -- source-new | |
| "提案來源new" text, | |
| -- speakers | |
| "發言委員" plv8x.json, | |
| -- committees | |
| "委員會" plv8x.json, | |
| -- offices | |
| "機關" text, | |
| -- notes | |
| "備註" text | |
| ); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment