database design issue - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

database design issue

database design issue# Database - 数据库

l*k2003-07-14 07:07

1 楼

in oracle, I am trying to design a database, I am facing a problem in
preventing duplicate numbers.
I make several table to generate their own PK upon insertion,
some tables's PK will be used as FK by other table(s). How do I
prevent an careless insertion that produce another PK for the
same row??? can I boundle other fields with PK?
If I want to write a scripts that insert FK automatically to other
table upon generation in parent table, then only do updates to those
table, will this be a good s

a*a2003-07-14 07:07

2 楼

dont fully understand your question. but you can create a PK with
more than 1 col.. forgot what's that called now. a com.... pk

【在 l*****k 的大作中提到】

: in oracle, I am trying to design a database, I am facing a problem in
: preventing duplicate numbers.
: I make several table to generate their own PK upon insertion,
: some tables's PK will be used as FK by other table(s). How do I
: prevent an careless insertion that produce another PK for the
: same row??? can I boundle other fields with PK?
: If I want to write a scripts that insert FK automatically to other
: table upon generation in parent table, then only do updates to those
: table, will this be a good s

m*c2003-07-14 07:07

3 楼

Why don't you create a single table to keep track the PK - This table will
have only one column - ID, and everytime you need to create a new PK for any
table, just take the value of ID and then increase it by 1 (so next time you
will get different value), this way, every PK will be unqiue cross whole
schema.

【在 l*****k 的大作中提到】

l*k2003-07-14 07:07

4 楼

My auto_increment PK is implemented by sequence, there are several
sequences that keep track of different PKs in different table.
all the confusion is generated by user request, they strongly
ask for parallel use of their naming system... I will reformulate
my question later...
right now, I am having problem with my trigger generating script, some
trigger compile with error, while some went through fine... really weird

【在 m**c 的大作中提到】

:
: Why don't you create a single table to keep track the PK - This table will
: have only one column - ID, and everytime you need to create a new PK for any
: table, just take the value of ID and then increase it by 1 (so next time you
: will get different value), this way, every PK will be unqiue cross whole
: schema.