Skip to content

Instantly share code, notes, and snippets.

@audreyt
Created March 23, 2013 08:29
Show Gist options
  • Select an option

  • Save audreyt/5227000 to your computer and use it in GitHub Desktop.

Select an option

Save audreyt/5227000 to your computer and use it in GitHub Desktop.
English column names for ly dump
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