[453_tmc] Re: Database

  • From: "Chris Rodgers" <Rodger4@xxxxxxxxxxx>
  • To: 453_tmc@xxxxxxxxxxxxx
  • Date: Mon, 13 Oct 2008 21:11:32 -0400

We need to allow users the ability to set default cameras on the 6 windows (window 5 is the main fixed camera, so you should only allow type 1--fixed--cameras to it, and only type 2--ptz--cameras to window 6).
I'm not sure I understand everything you are going to have on the admin page. Do you have a drawing or something of what you are making?
On Mon, 13 Oct 2008 20:51:59 -0400, Swati Saxena <ssaxena@xxxxxxxxxxxxx> wrote: 


Alright.
Can Joe and Chris tell me if there is any need of having the camera table on 
the admin page at all if we have the vehicle and image tables??
On Mon, Oct 13, 2008 at 8:42 PM, Chris Rodgers <Rodger4@xxxxxxxxxxx> wrote:
Can we just leave that as a "if we have time" thing? I think it would only 
be useful if we had replays, and we don't have that yet.


On Mon, 13 Oct 2008 20:24:59 -0400, Chris Rodgers <Rodger4@xxxxxxxxxxx>
wrote:

 I don't think we've talked about it.
On Mon, 13 Oct 2008 20:03:49 -0400, Swati Saxena <ssaxena@xxxxxxxxxxxxx> 
wrote:

 Who all are updating the history table in their components??


On Mon, Oct 13, 2008 at 7:53 PM, Chris Rodgers <Rodger4@xxxxxxxxxxx>
wrote:
I've included pics of the db and who is using what. The lines represent 
relations, and these keys are things that we all use but not directly
(except for cameraid).

Yellow - Chris
Blue - Joe
Red - Dan (haha, now you know!)
Purple - Joe and Matt
User and defaultcams - Swati
Image and Vehicle table updating - Logen

Also, Swati, use this most recent .sql file... I forgot to delete
"Image"
from the image table in my previous e-mail.

To address Matt:
WindowCamera holds values of cameraids in the camera table. The other 
stuff corresponds to very similarly named attributes in the "Vechile"
table.


On Mon, 13 Oct 2008 19:19:52 -0400, <mgarren@xxxxxxxxxxx> wrote:

 Swati,



   Definitely double check with Chris, but the values I'm using are:

WindowCamera[5]
trackDirection
trackDistance (Please don't make this field over 700, and realistically 
I
would imagine it should never really be over about 300-500, what does 
everyone think?)
WindowCamera[6]
trackSpeed

                             -Matt

 Hey Guys
I need yu all to tell me what all tables and fields are you guys using 
in
your respective components,accordingly i will have to set up the Admin 
Page
And also modify/get rid off some fields and/or tables
Reply is a must...

Thanks
Swati

Other related posts:

  1. Home
  2. 453_tmc
  3. Archive
  4. 10-2008