Vite Falcon

128 reputation

	128 reputation	bio	website		visits	member for	1 year, 1 month
3 badges		location	Edinburgh, United Kingdom		seen	Apr 16 '12 at 9:05

9 Actions

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?**