Add Tickets Database Table

bmwhiteh / GreenwayProject_AdminPortal

This is Team 3 Repository for the IPFW/ City of Fort Wayne Admin Portal

0 stars 0 forks source link

Add Tickets Database Table #32

Closed andreamoorman closed 7 years ago

andreamoorman commented 7 years ago

Add a database table named Tickets. This table should have the following attributes: strUserID dtTicketsOpened strTicketDiscription imgTicketImageFilePath dtTicketClosed strTicketType bitUrgent

bmwhiteh commented 7 years ago

Table: tickets Columns:

intUserId int PRIMARY
dtTicketOpen date
dtTicketClose date
strImageFilePath text
strDescription text
strType varchar(30)
bitUrgent bit(2)