Tabbatar da amincin bayanan ku
Wani yankin bayanan yanar gizo, a mafi sauki, shi ne nau'in bayanan da aka yi amfani da shi a cikin wani babban fayil. Wannan nau'in bayanai zai iya zama nau'in ginawa (kamar mahaɗi ko kirtani) ko nau'in al'ada wanda ya ƙayyade ƙuntatawa akan bayanai.
Shigar da Bayanan Bayanai da Ƙungiyoyi
Idan ka shigar da bayanai a cikin wani nau'i na intanet na kowane irin - ko kawai sunanka da imel, ko aikace-aikacen aiki na cikakke - wani bayanan yanar gizo yana adana bayanan da kake ciki a bayan al'amuran. Wannan bayanan yana kimanta shigarwarku bisa tushen saiti. Alal misali, idan ka shigar da zip zip, database yana buƙatar samun lambobi biyar, ko don cikakkiyar lambar zip ta US: lambobi biyar masu biyo baya, sannan lambobi huɗu. Idan ka shigar da sunanka a cikin filin zip, ƙila za a yi la'akari da bayanan.
Shi ke nan saboda database yana gwada shigarwarku kan yankin da aka tsara don filin zip code. Wani yanki ne mai nau'in nau'in bayanai wanda zai iya hada da ƙuntataccen zaɓi.
Fahimtar Rukunin Database
Don fahimtar wani yanki na yanar gizo, bari muyi la'akari da wasu fannoni na bayanai:
- Shirin tsari na ƙayyade saitunan halayen , wanda ake kira ginshiƙai ko filayen. Alal misali, idan kana da teburin "Bayanin Sadarwar Abokin Hulɗa," zai iya haɗa halayen na FirstName, LastName, JobTitle, StreetAddress, City, State, ZipCode, PhoneNumber da Email.
- Kowace sifa yana da yanki wanda ya bayyana dabi'u mai karɓa. Wannan zai iya haɗa da nau'in bayanai, tsawonsa, dabi'u da wasu cikakkun bayanai.
Alal misali, yankin don wani siginar Zakaren Ƙaƙwalwar ajiya zai iya ƙayyade nau'in bayanai, irin su lamba, yawanci ana kira INT ko INTEGER, dangane da bayanan. Ko mai zanewa na yanar gizo zai iya zaɓar don bayyana shi a matsayin hali, yawanci ake kira CHAR. Ana iya ƙayyade alamar da ake bukata don buƙatar wani tsayin daka, ko kuma an ba da darajar maras kyau ko maras kyau.
Lokacin da ka tattaro dukan abubuwan da ke bayyana wani yanki, za ka ƙare tare da nau'in bayanan da aka ƙera, wanda ake kira "nau'in bayanan mai amfani" ko UDT.
Game da Aminci na Gaskiya
Abubuwan da aka yarda da halayen wani sifa suna ƙirƙirar mutuncin yankin , wanda ke tabbatar da cewa duk bayanan da ke cikin filin yana da alamun ƙimar.
An tabbatar da mutuncin yankin ta hanyar:
- Nau'in bayanai, irin su mahaɗan, hali ko ƙaddara
- Yanayin da aka ba da izini na tsawon lokaci
- Zangon, yana bayyana ƙananan da ƙananan iyaka
- Duk wasu ƙuntatawa , ko ƙuntatawa akan dabi'u masu iyaka. Alal misali, hanyar filin zip na Amurka za ta iya aiwatar da cikakken lambar ZIP + 4 , ko kuma cikakken lambobi tara.
- Irin goyon bayan NULL, ko kuma wata alama ce ta iya samun wani abu maras sani, ko NULL darajar
- Ƙimar tsoho, idan wani
- Tsarin ranar, idan ya dace (alal misali, dd / mm / yy ko mm / dd / yyyy)
Samar da wani Yanki
Don bayanan bayanai da suke amfani da SQL (Structured Query Language) ko wani dandano na SQL, yi amfani da CREATE DOMAIN SQL umurnin.
Alal misali, bayanin da aka yi a nan ya haifar da wani nau'i mai suna ZipCode na nau'i na nau'i na CHAR tare da haruffa biyar. NULL, ko ba'a sani ba, ba a yarda ba. Tsarin bayanai dole ne a fada tsakanin "00000" da kuma "99999." Ya kirkiro wani nau'i na lambar ZipCode na nau'i na nau'i na CHAR tare da haruffa biyar. NULL, ko ba'a sani ba, ba a yarda ba. Tsarin bayanai dole ne a fada tsakanin "00000" da "99999."
CREATE DOMAIN ZipCode CHAR (5) BA NULL BUKATA (KASHI> '00000' DA ZAMA
Kowane irin bayanai yana samar da wata hanya ta ƙayyade jerin ƙuntatawa da ka'idojin da suke gudanar da bayanai masu iyaka, koda kuwa ba ya kira shi yanki ba. Dubi bayanan bayanan ku na bayanai don cikakkun bayanai.