Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Reference Table with temporary ids
- ╔════╦════════════╗
- ║ id ║ Name ║
- ╠════╬════════════╣
- ║ -1 ║ Blubb ║
- ║ -3 ║ Bla ║
- ║ -7 ║ Plisch ║
- ╚════╩════════════╝
- ^
- ╔════╦════════╦═════════════╗
- ║ id ║ ref_id ║ Name ║
- ╠════╬════════╬═════════════╣
- ║ 1 ║ -1 ║ Refs Blubb ║
- ║ 2 ║ -3 ║ Refs Bla ║
- ║ 3 ║ -7 ║ Refs Plisch ║
- ╚════╩════════╩═════════════╝
- Reference Table with one valid and two temporary ids
- ╔════╦════════════╗
- ║ id ║ Name ║
- ╠════╬════════════╣
- ║ 42 ║ Blubb ║ <- -1 changed to 42 (bubbles up to depending tables)
- ║ -3 ║ Bla ║
- ║ -7 ║ Plisch ║
- ╚════╩════════════╝
- ^
- ╔════╦════════╦═════════════╗
- ║ id ║ ref_id ║ Name ║
- ╠════╬════════╬═════════════╣
- ║ 1 ║ 42 ║ Refs Blubb ║
- ║ 2 ║ -3 ║ Refs Bla ║
- ║ 3 ║ -7 ║ Refs Plisch ║
- ╚════╩════════╩═════════════╝
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement