请在学生详细信息中更正此数据类型 [英] please correct this datatypes in student details

问题描述

你好朋友，
下面我将详细介绍具有数据类型的学生属性.请更有效地更正此数据类型
1.student_reg_no-int
2.student_id -int
3.student_name -varchar(50)
4.Dob -date
5.性别-char(1)
6.phone_number -varchar(15)
7.email_id-varchar(100)，
8.House_door_no-varchar(10)，因为门号有时包含字母
9.街道-varchar(100)
10.city -varchar(50)
11.state -varchar(50)
12.zipcode-int
13.country-varchar(30)

Hello friends,
Below i give the details of student attributes with datatypes. please correct this datatypes as efficiently
1.student_reg_no - int
2.student_id -int
3.student_name -varchar(50)
4.Dob -date
5.gender - char(1)
6.phone_number -varchar(15)
7.email_id - varchar(100),
8.House_door_no - varchar(10) because door number sometimes contain letters
9.street -varchar(100)
10.city -varchar(50)
11.state -varchar(50)
12.zipcode-int
13.country-varchar(30)

推荐答案

为什么会有一个reg no和一个ID?他们不是同一回事吗?如果没有，为什么它们不同?

电子邮件不限于100个字符，最多可以包含256个字符，其中最多64个字符位于"@"字符的左侧.

为什么房门号要留10个字节?有些名称会更长，将其称为数字"会造成混淆.将其设置为streetAddress，Town，County等，或将文本保留在一个字段中-看看Outlook之类的东西，他们这样做是有原因的.

邮政编码不应该是int-美国的是，但(例如)英国的是2个字母(2个)或3个数字(2个字母).由于您允许使用国家/地区，因此您不应将输入内容限制为国家标准...

为什么只有一部电话?移动电话和座机是常见的，有些具有多个移动电话. Skype等?

Why have you got a reg no and an ID? Are they not the same thing? If not, why are they different?

Emails are not limited to 100 characters, they can be up to 256 characters, up to 64 of which are to the left of the ''@'' character.

Why allow 10 bytes for house door number? Some names will be longer, and calling it "number" is confusing. Make it streetAddress, Town, County, etc. or keep the text as a single field - look at something like Outlook, they do it that way for a reason.

Zipcodes should not be int - US ones are, but (for example) UK ones are 2 alpha, 2 or three numeric, 2 alpha. Since you are allowing for countries, you should not restrict inputs to national standards...

Why only one phone? Mobile and landline are common, and some have multiple mobile. Skype and so forth?

这篇关于请在学生详细信息中更正此数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！