Click here to Skip to main content
16,021,997 members
Home / Discussions / Database
   

Database

 
GeneralRe: Database ADO exception on adding new record Pin
Richard MacCutchan16-Oct-20 4:53
mveRichard MacCutchan16-Oct-20 4:53 
AnswerRe: Database ADO exception on adding new record Pin
CHill6016-Oct-20 5:18
mveCHill6016-Oct-20 5:18 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 1:58
Peter Mortier19-Oct-20 1:58 
AnswerRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 2:00
Peter Mortier19-Oct-20 2:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 7:07
Victor Nijegorodov19-Oct-20 7:07 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 8:40
Peter Mortier20-Oct-20 8:40 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov20-Oct-20 9:29
Victor Nijegorodov20-Oct-20 9:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh13-Oct-20 23:17
karengsh13-Oct-20 23:17 
I refer to the use case as per Swagger documentation

Swagger UI[^]

I need help to know the following:
1) whether the table pets, table users and table orders below is correct

Create table pets (
petId INTEGER IDENTITY PRIMARY KEY,
NAME VARCHAR(30) NOT NULL,
PHOTOURL VARCHAR(30) NOT NULL,
User userId,
TAGS VARACHR(20) NOT NULL,
STATUS ENUM(20)
PRIMARY KEY (petId),
FOREIGN KEY (userId) REFERENCES Users(userId)
);

CREATE TABLE Orders (
    OrderID int PRIIMARY KEY,
    OrderNumber int NOT NULL,
    petId int,
    quantity int NOT NULL,
    shipDate DATE NOT NULL,
    STATUS VARCHAR(30) NOT NULL, // can we use Enum here ?
    PRIMARY KEY (OrderID),
    FOREIGN KEY (petId) REFERENCES Pets(petId)
    Not sure to include User based on the Swagger document
); 

CREATE TABLE Users(
UserID int PRIMARY KEY,
UserName VARCHAR(30) NOT NULL,
FirstName VARCHAR(30) NOT NULL,
LastName VARCHAR(30) NOT NULL,
EMAIL VARCHAR(30) NOT NULL,
PASSWORD VARCHAR(30) NOT NULL,
PHONE VARCHAR(30) NOT NULL,
UserStatus VARCHAR(30) NOT NULL,


2) whether store entity is needed ?

Please help me on above as I am not good with DB and have problem in understanding swagger documentation.

3) If I were to use JPA data in Spring, do I use Custom query for querying the status ?
Tks
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 22:37
Member 1260015012-Oct-20 22:37 
AnswerRe: Should I store files in a database? Pin
Richard Deeming12-Oct-20 22:54
mveRichard Deeming12-Oct-20 22:54 
QuestionMYSQL Pin
Member 147129666-Oct-20 10:21
Member 147129666-Oct-20 10:21 
AnswerRe: MYSQL Pin
ZurdoDev6-Oct-20 10:34
professionalZurdoDev6-Oct-20 10:34 
QuestionDatabase scripts version control process/strategy? Pin
Member 1363071429-Sep-20 6:06
Member 1363071429-Sep-20 6:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 7:48
David Mujica29-Sep-20 7:48 
AnswerRe: Database scripts version control process/strategy? Pin
ZurdoDev29-Sep-20 9:05
professionalZurdoDev29-Sep-20 9:05 
QuestionSimple Database design Pin
fdanos23-Sep-20 20:23
professionalfdanos23-Sep-20 20:23 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 20:54
Victor Nijegorodov23-Sep-20 20:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 12:18
professionalMycroft Holmes24-Sep-20 12:18 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 2:35
professionalfd97507-Sep-20 2:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 4:18
professionalJörgen Andersson7-Sep-20 4:18 
GeneralRe: Why does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 21:14
professionalfd97507-Sep-20 21:14 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 7:03
professionalZurdoDev21-Sep-20 7:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 14:51
rodgerm25-Aug-20 14:51 
AnswerRe: How to use a FileInfo control to add a filename to an Access database Pin
Richard MacCutchan25-Aug-20 21:16
mveRichard MacCutchan25-Aug-20 21:16 
QuestionDATABASE KEY Pin
Member 1492238425-Aug-20 0:42
Member 1492238425-Aug-20 0:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.