Is this a correct table structure for my database?

Hi all,

I'm making an log-viewer app for a game that I play - the game has
instant messaging in-game, and stores the chat logs from each of the
players' chats locally in txt files. I'll be using a sql compact
database embedded in the app for the storage.

The structure I've got so far is simple - just two tables:

tblChatChannels
  (key) colChannelId
  (key) colChannelOpenedTime
  colChannelName
  colChannelSubscriber


tblChats
  (key) colChatTime
  (key) colChannelId
  colChatSpeaker
  colChatBody

The main thing I'm confused about is the fact that my "many" table -
tblChats only has 1/2 of the "one" table's key as foreign. Is this a
kosher thing to do?


Thanks for any thoughts,

cdj