Search code examples
databasenosqlcassandradatamodel

makeing datamodel in cassandra db

i am new in Cassandra db. need help to create data model. i have db in PostgraySQL now i want to switch over to Cassandra (installation completed).

DB name = Automation

Table = Appliance List Fields = appliance id(auto increment,int), appliance name(varchar), appliance add(boolean)

Table = Appliance Keys Fields = appliance key (varchar), appliance id(foreign key of Appliance List table)

Thank you

Solution

  • Have a keyspace named Automation

    Then crate 2 column families 

    Appliance List Fields

Appliance Keys Fields

    Create the columns accordingly

    Appliance List Fields will have columns 

    appliance id

appliance name

appliance add

    P.S. There is no in-built auto-increment in Cassandra . You will need to use counter.