summaryrefslogtreecommitdiff
path: root/dbconf/pgsql
diff options
context:
space:
mode:
authorꦌꦫꦶꦏ꧀ꦦꦿꦧꦮꦑꦩꦭ꧀ <erik@darapsa.co.id>2021-07-25 21:00:57 +0800
committerꦌꦫꦶꦏ꧀ꦦꦿꦧꦮꦑꦩꦭ꧀ <erik@darapsa.co.id>2021-07-25 21:00:57 +0800
commitd071b989f94d82709ba6a088056e6d4629c1b7c7 (patch)
tree275257479697c8d9dcfa6aad083d16e774c9809f /dbconf/pgsql
parent6d12f3107f5a74700749b4b958b7880a659136e1 (diff)
SiCepat DB table prototypes
Diffstat (limited to 'dbconf/pgsql')
-rw-r--r--dbconf/pgsql/sicepat_destination.pgsql7
-rw-r--r--dbconf/pgsql/sicepat_origin.pgsql5
2 files changed, 12 insertions, 0 deletions
diff --git a/dbconf/pgsql/sicepat_destination.pgsql b/dbconf/pgsql/sicepat_destination.pgsql
new file mode 100644
index 0000000..c4856c3
--- /dev/null
+++ b/dbconf/pgsql/sicepat_destination.pgsql
@@ -0,0 +1,7 @@
+Database sicepat_destination sicepat_destination.txt __SQLDSN__
+Database sicepat_destination DEFAULT_TYPE VARCHAR(64)
+Database sicepat_destination COLUMN_DEF "code=CHAR(8) NOT NULL PRIMARY KEY"
+Database sicepat_destination COLUMN_DEF "district=VARCHAR(64) NOT NULL"
+Database sicepat_destination COLUMN_DEF "city=VARCHAR(64) NOT NULL"
+Database sicepat_destination COLUMN_DEF "province=VARCHAR(32) NOT NULL"
+Database sicepat_destination INDEX district
diff --git a/dbconf/pgsql/sicepat_origin.pgsql b/dbconf/pgsql/sicepat_origin.pgsql
new file mode 100644
index 0000000..b5c1ff0
--- /dev/null
+++ b/dbconf/pgsql/sicepat_origin.pgsql
@@ -0,0 +1,5 @@
+Database sicepat_origin sicepat_origin.txt __SQLDSN__
+Database sicepat_origin DEFAULT_TYPE VARCHAR(64)
+Database sicepat_origin COLUMN_DEF "code=CHAR(3) NOT NULL PRIMARY KEY"
+Database sicepat_origin COLUMN_DEF "city=VARCHAR(64) NOT NULL"
+Database sicepat_origin INDEX city