phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ciureanu Constantin <ciureanu.constan...@gmail.com>
Subject Re: FOREIGN KEY
Date Thu, 12 May 2016 13:22:21 GMT
CREATE TABLE IF NOT EXISTS TELEPHONE (
CustomerID INT,
TelephoneType VARCHAR,
TelephoneNumber VARCHAR
CONSTRAINT PK PRIMARY KEY (CustomerID, TelephoneType)
);

In case it's still not unique, add the TelephoneNumber too.

...
CONSTRAINT PK PRIMARY KEY (CustomerID, TelephoneType, TelephoneNumber )

2016-05-12 15:14 GMT+02:00 Ciureanu Constantin <
ciureanu.constantin@gmail.com>:

> Just create a new first unique field CustomerID + TelephoneType to play
> the PK role, something has to be unique there and a HBase table needs a Key
> (this concatenation of 2 or more values is valid in case it's unique
> otherwise invent some other 3rd part or risk to lose phone numbers that are
> "duplicates" - eg. for the same CustomerID and Type).
>
> 2016-05-12 13:24 GMT+02:00 Mariana Medeiros <63msim@gmail.com>:
>
>> Hello,
>>
>> Do you know how to create an HBase table with no primary key and with a
>> foreign key?
>>
>> Something like:
>>
>> (TABLE) CUSTOMER:
>> CustomerID (pk)
>> CustomerName
>>
>>
>> (TABLE) TELEPHONE:
>> CustomerID (fk)
>> TelephoneType
>> TelephoneNumber
>>
>>
>> How to create a telephone table like that?
>>
>> Thank you.
>>
>
>

Mime
View raw message