日時: | 2023-12-03 |
---|---|
作: | voluntas |
バージョン: | 2023.1 |
url: | https://voluntas.github.io |
この記事が良いと思ったらこの記事に Star をお願いします
CREATE TABLE public.customer (c_id numeric(5,0) NOT NULL, c_d_id numeric(2,0) NOT NULL, c_w_id numeric(4,0) NOT NULL, c_first character varying(16), c_middle character(2), c_last character varying(16), c_street_1 character varying(20), c_street_2 character varying(20), c_city character varying(20), c_state character(2), c_zip character(9), c_phone character(16), c_since timestamp without time zone, c_credit character(2), c_credit_lim numeric(12,2), c_discount numeric(4,4), c_balance numeric(12,2), c_ytd_payment numeric(12,2), c_payment_cnt numeric(8,0), c_delivery_cnt numeric(8,0), c_data character varying(500)) WITH (fillfactor='50'); | |
CREATE UNIQUE INDEX customer_i2 ON public.customer USING btree (c_w_id, c_d_id, c_last, c_first, c_id) TABLESPACE pg_default ; | |
ALTER TABLE public.customer ADD CONSTRAINT customer_i1 PRIMARY KEY (c_w_id, c_d_id, c_id); | |
CREATE TABLE public.district (d_id numeric(2,0) NOT NULL, d_w_id numeric(4,0) NOT NULL, d_ytd numeric(12,2), d_tax numeric(4,4), d_next_o_id numeric, d_nam |
日時: | 2023-12-03 |
---|---|
作: | voluntas |
バージョン: | 2023.1 |
url: | https://voluntas.github.io |
この記事が良いと思ったらこの記事に Star をお願いします
日時: | 2025-03-02 |
---|---|
作: | 時雨堂 |
バージョン: | 2025.1 |
url: | https://sora.shiguredo.jp/ |