yugi
2012-05-29 14:09:59 UTC
one of the tables i got is like
create table user(
user_number(8),
First_name varchar(30) not null,
Last_name varchar(30) not null,
DOB date not null,
nationality varchar (30)not null ,
gender char (1) not null ,
address varchar(30) not null,
Primary key(user_ID)
foreign key(profile_ID));
when i start describing them in the table it goes like
column name NULL key type ...
--------------------------------------------------------------------
user_ID null pk varchar
profile_ID null fk varchar
my question is , is it right to put both pk & fk as null?
or should i make fk Not-Null?