Bids: Difference between revisions
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
The Bids table gives information regarding the bids for the topics given by a particular user. | The Bids table gives information regarding the bids for the topics given by a particular user. | ||
== Bids Variable Documentation == | == Topic Bids Variable Documentation (Reimplementation) == | ||
{| class="wikitable" | '''Note:''' This table has been renamed from ''bids'' to ''topic_bids''. | ||
!Field Name !!Type !! | |||
|- | {| class="wikitable" | ||
! | !Field Name !!Type !!Description | ||
|int(11) | |- | ||
!id | |||
|int(11) | |||
|Unique ID for each bids record. | |||
|- | |||
!topic_id | |||
|int(11) | |||
|Name of the Topic. | |||
|- | |||
!user_id | |||
|int(11) | |||
|User ID who bid for the Topic. | |||
|- | |||
!created_at | |||
|datetime | |||
|Date time value when the record was created. | |||
|- | |||
!updated_at | |||
|datetime | |||
|Date time value when the record was updated. | |||
|- | |||
!priority | |||
|int(11) | |||
|Priority Level for that Bid. | |||
|} | |||
== Bids Variable Documentation (2023 version) == | |||
{| class="wikitable" | |||
!Field Name !!Type !!Description | |||
|- | |||
!id | |||
|int(11) | |||
|Unique ID for each bids record. | |Unique ID for each bids record. | ||
|- | |- | ||
! | !topic_id | ||
|int(11) | |int(11) | ||
|Name of the Topic. | |Name of the Topic. | ||
|- | |- | ||
! | !user_id | ||
|int(11) | |int(11) | ||
|User ID who bid for the Topic. | |User ID who bid for the Topic. | ||
|- | |- | ||
! | !created_at | ||
| | |datetime | ||
|Date time value when the record was created. | |Date time value when the record was created. | ||
|- | |- | ||
! | !updated_at | ||
| | |datetime | ||
|Date time value when the record was updated. | |Date time value when the record was updated. | ||
|- | |- | ||
! | !priority | ||
|int(11) | |int(11) | ||
|Priority Level for that Bid. | |Priority Level for that Bid. | ||
Latest revision as of 03:59, 9 December 2025
The Bids table gives information regarding the bids for the topics given by a particular user.
Topic Bids Variable Documentation (Reimplementation)
Note: This table has been renamed from bids to topic_bids.
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | Unique ID for each bids record. |
| topic_id | int(11) | Name of the Topic. |
| user_id | int(11) | User ID who bid for the Topic. |
| created_at | datetime | Date time value when the record was created. |
| updated_at | datetime | Date time value when the record was updated. |
| priority | int(11) | Priority Level for that Bid. |
Bids Variable Documentation (2023 version)
| Field Name | Type | Description |
|---|---|---|
| id | int(11) | Unique ID for each bids record. |
| topic_id | int(11) | Name of the Topic. |
| user_id | int(11) | User ID who bid for the Topic. |
| created_at | datetime | Date time value when the record was created. |
| updated_at | datetime | Date time value when the record was updated. |
| priority | int(11) | Priority Level for that Bid. |
E/R diagram for Parents Tables
No Tables were referred by the Bids Table as Foreign Key Relationship.
E/R diagram for Child Tables
No Tables were referred by the Bids Table as Foreign Key Relationship.
Back to Database Tables Main page.