2011-11-03, 01:42 PM
Eos Wrote:Because there is no magic date_of_first_completed_quest column, that was a reference to a concept, not an entity.
It would be found by joining the Character table to earliest entry from the QuestComplete or QuestPerform table. Nexon doesn't even store the character level in the Character table, it's in it's own table, so why would you assume something as random and unnecessary as first_completed_quest would exist as a dedicated field in a table? Each active quest has it's own date/time field per character indicating when it was started and finished, to find the earliest you would specifically query the min() date of the appropriate table and join that result to the character table. Thank you ever so much for explaining to me the nomenclature of the job I've had for over a decade, truly.
It can always be created within its own temporary table as a column and thus as an entity. Sometimes when you try to explain things the simplest possible way people divert from trying to understand the explanation and put their own meaning to it. When I mentioned "column" it was implied that it would be the min date from a separate table (also, never did I assume such a date column exists). I think you got the idea from the start though. This argument is pointless.
And nice job showing off how smart you are. Fyi, I also work with SQL as a developer (not to rub it in of course).

