Geodatabase ArcSDE/Oracle : PK and FK
Posted on 2004-08-12
I'm coming from ERD diagrams world and planned there geodatabase. Then I was about to create Oracle tables via ArcCatalog
(I had some non-graphic classes that I wanted to append to to the feature classes).
I was very surprised when I saw no choice to determine PK and FK I had designed for my tables?
Do you know it is necessary to have normal tables created via ArcCatalog or I can do it via e.g. Erwin?
(the existing feature class has an attribute that is FK, i.e. PK of one of my normal table and this normal ables is then related to other etc.)
The applications are going to use Map(Arc?) Objects to work with the geodatabase. Will they be able to access my normal tables if I create them via Erwin? (I investigated a bit and saw that all registered tables are put in one SDE system table).
But when I define the relation, no FK were established between the tables ?! Is this normal for hte geodatabase?