SQL database design

[Wimnat]

I suck at database design so I have no idea what to do with this data...

I have recorded some data from voip calls. there are different types of packet in each call i.e. sip and rtp. I want to write each packet to a database.

Should i;

• Create two tables - one for sip packets from every call and one for rtp packets from every call
• Create a table for each call which accepts all the fields from rtp and sip (a lot of fields will get left blank)

Or is there a (c)? I've no idea so please help!

 

[Wimnat]

Each packet has many different fields.

A SIP packet may have say 5 fields like "to" and "from" etc

An RTP packet will have a different number of fields with things like "version", "identifier" etc.