Timeline for How do I design this Draft Table and select from it?
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 2, 2018 at 21:09 | comment | added | Toleo | @GerardH.Pille nope. | |
| Apr 2, 2018 at 20:13 | comment | added | Gerard H. Pille | Are you from Barcelona? | |
| Apr 2, 2018 at 18:13 | comment | added | Toleo |
@GerardH.Pille Like this? db-fiddle.com/f/weourGGnXWj2b6xu7mNfAp/18 , it works properly with a LEFT JOIN on posts, But How can I make it an INNER JOIN? Since deleting a post that exists, will make it like a row from titles.
|
|
| Apr 2, 2018 at 17:56 | comment | added | Gerard H. Pille | If a draft can have only one title, the titles table has no reason of being. Just add the title column to the drafts table. Now you can trop the tid column from the posts table too. | |
| Apr 2, 2018 at 15:12 | vote | accept | Toleo | ||
| Apr 2, 2018 at 15:11 | comment | added | Toleo |
@GerardH.Pille Is it possible to provide me witth the best design for it? Because i built it to be compact using the tp_id.
|
|
| Apr 2, 2018 at 14:52 | answer | added | Gerard H. Pille | timeline score: 1 | |
| Apr 2, 2018 at 14:39 | comment | added | Gerard H. Pille | I think your design is flawed, having two records for a single draft. The draft record could have had a t_id and a p_id iso. tp_id + t. | |
| Apr 2, 2018 at 11:54 | history | edited | Toleo | CC BY-SA 3.0 |
added 100 characters in body
|
| Apr 2, 2018 at 11:43 | comment | added | Toleo |
@GerardH.Pille I will give a try to make the second INNER JOIN a derived query to solve this problem. . . After trying, it doesn't seem to get results either.
|
|
| Apr 2, 2018 at 1:06 | answer | added | Gerard H. Pille | timeline score: 1 | |
| Apr 2, 2018 at 0:25 | comment | added | Gerard H. Pille | It looks logical to me that you have no results. You're asking for drafts having t = 1 and t = 2 in the same record. Impossible. | |
| Apr 1, 2018 at 23:04 | history | asked | Toleo | CC BY-SA 3.0 |