Jump to content

contract_term


SaranacLake
 Share

Recommended Posts

Is it necessary to have the units of measurement in a column name?

I want to add the column "contract_term" to my table, but it will store things in terms of MONTHS, so an annual membership would have a value of 12.  (This is easier than needing a second column for units or dealing with decimals.)

I could have "contract_term_mths" but that sorta looks weird.

Thoughts?

 

Link to comment
Share on other sites

Seems to me it would be better to have contract_start and contract_end date columns. If you will be needing historical data then you would have a table for storing each term start/end dates keyed to the user_id.

You will also gain a lot of flexibility with being able to do date calculations and Analytics.

Edited by benanamen
Link to comment
Share on other sites

23 minutes ago, benanamen said:

Seems to me it would be better to have contract_start and contract_end date columns. If you will be needing historical data then you would have a table for storing each term start/end dates keyed to the user_id.

You will also gain a lot of flexibility with being able to do date calculations and Analytics.

Wrong concept.

Not the start and end date of a specific contract.

The term of a generic contract.

Think "annual subscription", "one-month trial", etc.

 

Link to comment
Share on other sites

4 minutes ago, benanamen said:

Ok, so a subscription _ types lookup table with subscription_type_id, subscription_type_description

Then in data table you have subscription_type_id keyed to the lookup table.

Why do you do this?

I ask a specific question, and now you are giving me data modeling lessons?

Stop twisting what I asked for into something it's not.

 

 

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.