Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tPm54-00FC6S-0v
	for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 17:18:58 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tPm53-00D5xk-B7
	for pgsql-general@arkaria.postgresql.org; Mon, 23 Dec 2024 17:18:57 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1tPm53-00D5xc-0X
	for pgsql-general@lists.postgresql.org; Mon, 23 Dec 2024 17:18:56 +0000
Received: from fout-b6-smtp.messagingengine.com ([202.12.124.149])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1tPm50-001FkS-5U
	for pgsql-general@lists.postgresql.org; Mon, 23 Dec 2024 17:18:56 +0000
Received: from phl-compute-11.internal (phl-compute-11.phl.internal [10.202.2.51])
	by mailfout.stl.internal (Postfix) with ESMTP id 931C91140188;
	Mon, 23 Dec 2024 12:18:52 -0500 (EST)
Received: from phl-mailfrontend-02 ([10.202.2.163])
  by phl-compute-11.internal (MEProxy); Mon, 23 Dec 2024 12:18:52 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:cc:content-transfer-encoding:content-type:content-type:date
	:date:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm1; t=1734974332;
	 x=1735060732; bh=BK5xnydcCwua+Ut08kcXbc5BRnhSZPwryZmaIYyBKcQ=; b=
	vcyAvuL1v5YehFYhIAxTzeH4aEPyJljP7dErZ3NAm8sDNmaqvTTYYmoY7DuXSh/L
	Mxafx/445IyfHC2HJr80vRr+1FT00W8AjLpOz/T4I48wrEgI21mpEVBGhsszwdSs
	DGtpiSs6DngAuyJVUEnIv626xWm9vFaDFGlM5IDDQQ5CCZ0aYvgDPQ1eJIZ7V6kj
	bLKTbs7V+qX90nLQo4LbaGXxqZvcRVkGHhITa/KEfOgL3InD60MGnpynCeCuYPD5
	Ev/Xn5fSN97Njaa7vnlEX1zbU5Qh+8B6E6kRowv9SGUyTxgHPY7SPxT1vvOO0bRQ
	bDpsFld8/NCVGx214ihjAg==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:cc:content-transfer-encoding
	:content-type:content-type:date:date:feedback-id:feedback-id
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1734974332; x=
	1735060732; bh=BK5xnydcCwua+Ut08kcXbc5BRnhSZPwryZmaIYyBKcQ=; b=f
	gJtiZ0Nvc3JpLzrgHJeDWn8lYOXTYpyuxERkg3JNlVoRS14WHHZrdGQZW39PoAVs
	Vw1SEsAIJy0pj4Q/4BOGsEg5Q3a1iAVg0ae/6dxmCItCTmr6u+qJi067yiIl3wr6
	nkCuxBHnlmBWeVElV5ZdDBUR1y6G/azRuq5rpneeylgfO8rVf2nDED5ufBBlcucN
	QjufaTukynYN+LtVtW86XqwVUBNe4L1H67rS5LZQ1BKxnjrM/YCvY/0VaBJDTt3O
	9hTLdt4AIzIQliXbmRbKLi5F6p+Evp3oVLWHx+pOXUX4ymoo3tDw8ODbQyCSWx80
	u1sJVN24V08iJ4YkUg+sg==
X-ME-Sender: <xms:e5tpZ4eUKLt7knvuL5TATxoCqGraDjrGEzfBtSkqmGG4Pe8ye99knQ>
    <xme:e5tpZ6OjImwtdfyUnjZi-X1XkFR2iRZMWxdQmAJSAbu8uB7rH_nrtC6feC8ETXPsT
    jzJQaVSFGE6gLo>
X-ME-Received: <xmr:e5tpZ5h2aFVn6NesYUvlVyi8p2qw0h7ZftvYSs0bxgPg62v0hEW1dYW-0LpyzURCQPaMOL7bQff4lOogBUDpQUwcXGI>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrudduvddgfeehucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu
    rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh
    htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdej
    necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh
    esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhephfeviefhveelffeftdeh
    udekveefhfeftdegieefveetfffgfeehtdfftedutedtnecuvehluhhsthgvrhfuihiivg
    eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk
    lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpd
    hrtghpthhtoheprghgudehieejkedvjeesghhmrghilhdrtghomhdprhgtphhtthhopehr
    ohhnlhhjohhhnhhsohhnjhhrsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlh
    dqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg
X-ME-Proxy: <xmx:e5tpZ996CqEXSzjhZQeYqXYCa5zA5LN_jmp2g914G8zqpqh-0j0icA>
    <xmx:e5tpZ0tvst_YveHmUct2H6dvDbJsGN51ofrZSlT5mEJ6p9zElz2R9Q>
    <xmx:e5tpZ0FhAbNsaUZ5Sp6zxYgn33bRkT35UeVVLQT6WfurQkH8iO2INQ>
    <xmx:e5tpZzNggO3J8KXluceZviqakAOdHv2XsDb4nQz1ToWvmIXn6a9HRw>
    <xmx:fJtpZwJOokGM9Ae3xPiDUPEhyyqC_k92fDumRAorhpp1Ul4DDiAirg4Z>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon,
 23 Dec 2024 12:18:51 -0500 (EST)
Message-ID: <33c18624-ca8f-45d5-863a-9e730246fcf7@aklaver.com>
Date: Mon, 23 Dec 2024 09:18:50 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Need help in database design
To: Divyansh Gupta JNsThMAudy <ag1567827@gmail.com>,
 Ron Johnson <ronljohnsonjr@gmail.com>
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAHesJ5LES3aTDf=xp7NOwrADQ_HWC-Spsv7yLu9ZY+zxzZO53A@mail.gmail.com>
 <b450927c-49da-46e5-ad74-bf38ceff166b@aklaver.com>
 <CAHesJ5+ASNoSNMiC5Ms0Ts=gw7v2_UeBpUT=phujO4yE_XCbEw@mail.gmail.com>
 <CAHesJ5JbkCBZ2f_AvUr8+KWnGPAsobu4zyfnWm8bEeb7X9oqDQ@mail.gmail.com>
 <06e1f1ee-74b2-43a2-9a63-da20ae455ae2@aklaver.com>
 <CAHesJ5JLzhHiGSBSkJZ7x7rGgHeeByP=wWk1D5GG=x8cJ5YY6Q@mail.gmail.com>
 <CANzqJaBg5=iNXJDgk_saDD_nJAE_W=T0PxuT-SwC2902h0CG-Q@mail.gmail.com>
 <CAHesJ5+vu_HGNSwDGz4YdMyUb_Yq4oTuhKBzydutcUiG1ChOtA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAHesJ5+vu_HGNSwDGz4YdMyUb_Yq4oTuhKBzydutcUiG1ChOtA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/33c18624-ca8f-45d5-863a-9e730246fcf7%40aklaver.com>
Precedence: bulk

On 12/23/24 09:07, Divyansh Gupta JNsThMAudy wrote:
> Each row have a PK (gdid) that will uniquely refrence 50 k/v pair set
> 

Are the 50 key/value pairs there to just define a PK or are they going 
to be used in some other combination in queries?


-- 
Adrian Klaver
adrian.klaver@aklaver.com