July 29, 2022 at 8:44 am
Attach the database ER diagram , as you can see , there are symbols in front of the keys , eg. P , F , FK, key , red asterisk , two green lines , U etc , just would like to know what this symbols represent , what is its function ? is there any documnet on web explains it that I can refer to ?
thanks
July 29, 2022 at 9:14 am
I think I can help with most of that.
P = Primary Key
F = Foreign Key
The PK_ and FK_ are constraint names, these correspond with the P and Fs.
Red asterisk means that the column is not nullable.
Two green lines denote foreign key constraints.
U looks like a unique index (especially given the IX_ prefixed names above it), though the PK_ prefix makes it sound like a primary key.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 29, 2022 at 10:04 am
very thanks your reply .
is there any web page have the explanation as I still have query ?
July 29, 2022 at 10:14 am
Furthermore
What is the orange KEY symbol and IX mean ?
thanks
July 29, 2022 at 10:20 am
I can't give you a web page because I do not know which product you used to generate the E/R diagram. It wasn't a SQL Server database diagram, as far as I can see.
The orange key symbol denotes the primary key (PK) constraint. The P next to ID tells you that ID is part of the PK. In this case, as no other columns have a P next to them, you can assume that ID is the only column in the PK.
IX_ is a prefix often given to index names (this is not enforced).
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 29, 2022 at 10:28 am
Do you have access to the database containing this table? If you do, try generating the 'CREATE TABLE' script for it. When you see that, it should help explain what is going on.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 29, 2022 at 12:39 pm
I can't give you a web page because I do not know which product you used to generate the E/R diagram. It wasn't a SQL Server database diagram, as far as I can see.
The orange key symbol denotes the primary key (PK) constraint. The P next to ID tells you that ID is part of the PK. In this case, as no other columns have a P next to them, you can assume that ID is the only column in the PK.
IX_ is a prefix often given to index names (this is not enforced).
It is from Oracle
July 29, 2022 at 12:44 pm
Phil Parkin wrote:I can't give you a web page because I do not know which product you used to generate the E/R diagram. It wasn't a SQL Server database diagram, as far as I can see.
The orange key symbol denotes the primary key (PK) constraint. The P next to ID tells you that ID is part of the PK. In this case, as no other columns have a P next to them, you can assume that ID is the only column in the PK.
IX_ is a prefix often given to index names (this is not enforced).
It is from Oracle
This is a SQL Server community though, and you've posted in a SQL Server 2016 forum; you aren't in the right place if you are posting about Oracle. This would explain why Phil doesn't recognise the diagram, because they are expecting something based on SQL Server, not Oracle.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 29, 2022 at 2:14 pm
patrick chan wrote:Phil Parkin wrote:I can't give you a web page because I do not know which product you used to generate the E/R diagram. It wasn't a SQL Server database diagram, as far as I can see.
The orange key symbol denotes the primary key (PK) constraint. The P next to ID tells you that ID is part of the PK. In this case, as no other columns have a P next to them, you can assume that ID is the only column in the PK.
IX_ is a prefix often given to index names (this is not enforced).
It is from Oracle
This is a SQL Server community though, and you've posted in a SQL Server 2016 forum; you aren't in the right place if you are posting about Oracle. This would explain why Phil doesn't recognise the diagram, because they are expecting something based on SQL Server, not Oracle.
thanks reply ,
I just guess it is Oracle I am not sure , I am new to it .
this ER diagram is from the vendor , they just ask me to extract data from the database .
July 29, 2022 at 2:26 pm
thanks reply ,
I just guess it is Oracle I am not sure , I am new to it .
this ER diagram is from the vendor , they just ask me to extract data from the database .
You're being asked to extract data from a database, on the basis of an E/R diagram, when
a) You are new to databases.
b) You don't know what platform the database is running on.
is that right? That is a big ask. I think you are going to need help.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 31, 2022 at 12:17 am
patrick chan wrote:thanks reply ,
I just guess it is Oracle I am not sure , I am new to it .
this ER diagram is from the vendor , they just ask me to extract data from the database .
You're being asked to extract data from a database, on the basis of an E/R diagram, when
a) You are new to databases.
b) You don't know what platform the database is running on.
is that right? That is a big ask. I think you are going to need help.
exactly
thanks for reply
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply