"use strict";(self.webpackChunknewoaks_help=self.webpackChunknewoaks_help||[]).push([[1844],{1463:(e,n,r)=>{r(6540),r(4848)},5459:(e,n,r)=>{r.r(n),r.d(n,{assets:()=>c,contentTitle:()=>a,default:()=>d,frontMatter:()=>o,metadata:()=>s,toc:()=>u});const s=JSON.parse('{"id":"crashCourse/unique-key","title":"Set Up Unique Key for Your Database Table","description":"Objective of a Unique Key","source":"@site/userGuide/crashCourse/unique-key.md","sourceDirName":"crashCourse","slug":"/crashCourse/unique-key","permalink":"/guides/user/crashCourse/unique-key","draft":false,"unlisted":false,"tags":[],"version":"current","sidebarPosition":24,"frontMatter":{"sidebar_position":24},"sidebar":"sidebar","previous":{"title":"Create and Display Product Listings","permalink":"/guides/user/crashCourse/create-product"},"next":{"title":"How to Create Google Login","permalink":"/guides/user/crashCourse/google-login"}}');var t=r(4848),i=r(8453);r(1463),r(8175);const o={sidebar_position:24},a="Set Up Unique Key for Your Database Table",c={},u=[{value:"Objective of a Unique Key",id:"objective-of-a-unique-key",level:2},{value:"Instructions for Setting a Unique Key",id:"instructions-for-setting-a-unique-key",level:3}];function l(e){const n={code:"code",h1:"h1",h2:"h2",h3:"h3",header:"header",img:"img",li:"li",p:"p",strong:"strong",ul:"ul",...(0,i.R)(),...e.components};return(0,t.jsxs)(t.Fragment,{children:[(0,t.jsx)(n.header,{children:(0,t.jsx)(n.h1,{id:"set-up-unique-key-for-your-database-table",children:"Set Up Unique Key for Your Database Table"})}),"\n",(0,t.jsx)(n.h2,{id:"objective-of-a-unique-key",children:"Objective of a Unique Key"}),"\n",(0,t.jsx)(n.p,{children:"The primary purpose of a unique key is to prevent duplicate records in your database table."}),"\n",(0,t.jsx)(n.h3,{id:"instructions-for-setting-a-unique-key",children:"Instructions for Setting a Unique Key"}),"\n",(0,t.jsxs)(n.p,{children:[(0,t.jsx)(n.strong,{children:"Step 1:"})," Navigate to your project"]}),"\n",(0,t.jsxs)(n.ul,{children:["\n",(0,t.jsxs)(n.li,{children:["Go to ",(0,t.jsx)(n.strong,{children:"Project Admin"})," \u2192 ",(0,t.jsx)(n.strong,{children:"Tables"})]}),"\n",(0,t.jsx)(n.li,{children:"Navigate to your target table."}),"\n"]}),"\n",(0,t.jsxs)(n.p,{children:[(0,t.jsx)(n.strong,{children:"Step 2:"})," Click on ",(0,t.jsx)(n.strong,{children:"Set Unique Key"}),"."]}),"\n",(0,t.jsxs)(n.p,{children:[(0,t.jsx)(n.strong,{children:"Step 3:"})," Choose your unique key configuration:"]}),"\n",(0,t.jsxs)(n.ul,{children:["\n",(0,t.jsxs)(n.li,{children:[(0,t.jsx)(n.strong,{children:"Scenario 1:"})," Under ",(0,t.jsx)(n.strong,{children:"Table Columns"}),", select a single column (e.g., ",(0,t.jsx)(n.code,{children:"player_name"}),") to set as your unique key."]}),"\n",(0,t.jsxs)(n.li,{children:[(0,t.jsx)(n.strong,{children:"Scenario 2:"})," Under ",(0,t.jsx)(n.strong,{children:"Table Columns"}),", select two or more columns (e.g., ",(0,t.jsx)(n.code,{children:"player_name"})," + ",(0,t.jsx)(n.code,{children:"money_amount"}),") to create a composite unique key."]}),"\n"]}),"\n",(0,t.jsxs)(n.p,{children:[(0,t.jsx)(n.strong,{children:"Step 4:"})," Click ",(0,t.jsx)(n.strong,{children:"Save"})," button to apply your changes."]}),"\n",(0,t.jsxs)(n.p,{children:["This version improves clarity and structure for better readability.\n",(0,t.jsx)(n.img,{src:r(9665).A+"",width:"1331",height:"684"})]})]})}function d(e={}){const{wrapper:n}={...(0,i.R)(),...e.components};return n?(0,t.jsx)(n,{...e,children:(0,t.jsx)(l,{...e})}):l(e)}},8175:(e,n,r)=>{r.d(n,{A:()=>t});r(6540);var s=r(4848);function t(){return(0,s.jsx)("code",{children:"EZsite"})}},8453:(e,n,r)=>{r.d(n,{R:()=>o,x:()=>a});var s=r(6540);const t={},i=s.createContext(t);function o(e){const n=s.useContext(i);return s.useMemo((function(){return"function"==typeof e?e(n):{...n,...e}}),[n,e])}function a(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(t):e.components||t:o(e.components),s.createElement(i.Provider,{value:n},e.children)}},9665:(e,n,r)=>{r.d(n,{A:()=>s});const s=r.p+"assets/images/uniquekey-ba8c51545e55c446cea96dd4904b3c56.png"}}]);