128 reputation
3
bio website
location Edinburgh, United Kingdom
age 30
visits member for 2 years, 5 months
seen Aug 22 at 22:43

Apr
16
accepted Oracle: DB *partial* constraint?
Apr
16
comment Oracle: DB *partial* constraint?
@ypercube: Thanks for clarifying that. It seems this answer is good enough to be accepted :).
Apr
15
comment Oracle: DB *partial* constraint?
@miracle173: That sounds like a better option than cramming in more constratints in the table. If you could answer that below, I could accept your answer :)
Apr
15
comment Oracle: DB *partial* constraint?
Sorry, I had first accepted this answer and then realized there was something wrong. ORDER_ID cannot be NULL. And having this this way would mean ORDER_ID will be NULL for refunds. A refund is attached to an order hence it should be there. Moreover I see more potential in @miracle173's answer.
Apr
15
comment Oracle: DB *partial* constraint?
I haven't tested this myself but this seems a very feasible option :)
Apr
15
awarded  Supporter
Apr
15
awarded  Scholar
Apr
14
awarded  Student
Apr
14
asked Oracle: DB *partial* constraint?