Size Field in Entity

Toad Data Modeler
1

I have two suggestions.

Currently, the size field in Entities is an int. It is not big enough for some tables. Please allow it to hold larger numbers.

Second…It would also be helpful if I could put a formula in Size.

For instance, I know a child table will be about 10X this size of it’s parent table.

So, I could put =<%ParentTable>*10 in the child table’s Size.

Thanks,
Jay

Message was edited by: Spunkmeyer

2

Hi Jay,

thank you for your suggestions. I will make two different enhancement requests to have your suggestions considered and prospectively implemented.
Anyway, if you could provide us with some example or workflow for the first case, it could be very helpful.

Regards,
Lukas

3

Hi Jay,

  • change request concerning Size field- CR 89181
  • change request concerning formula input for size- 89183

regards,
Lukas

4

Hi Lukas,

Here is an example for case 1.

I have a table that will contain 3,000,000,000 records.

The largest value I can enter into the Size field is 2,147,483,647.

If I enter 2,147,483,648 or greater it change to to 0 when I apply.

Thanks,
Jay

5

Hi Jay,

thanks for the info. Anyway, these kinds of numbers are very exceptional, aren’t they. Maybe an easy workaround would be to use numbers in thousands or milions.
And for the second case, when do you think the formula should be interpreted? Size is not generated as it is a logical value.

Regards,
Lukas