English 中文(简体)
将这2个数据库栏合并为1个。
原标题:Possible to combine these 2 database columns into 1?

我有一个经常性的活动图,有<代码>RecurrenceType和RecurrenceMultiple栏。 RecurrenceType 是具有这些备选办法的表格的外在钥匙 (1) 每天2次 (3) 每周4次(月4日)<代码>RecurrenceMultiple,是一种分类,表明每次活动都有多个重复的时间框架。 几个例子

  • RecurrenceType=1, RecurrenceMultiple=1 : One time only
  • RecurrenceType=2, RecurrenceMultiple=1 : Every day
  • RecurrenceType=3, RecurrenceMultiple=1 : Every week
  • RecurrenceType=3, RecurrenceMultiple=2 : Every other week
  • RecurrenceType=4, RecurrenceMultiple=1 : Every month
  • RecurrenceType=4, RecurrenceMultiple=3 : Every 3rd month
  • RecurrenceType=4, RecurrenceMultiple=12 : Yearly

我愿以某种方式将这两个栏目合并起来,以便我能够引用,使我能够打上桌面。 我不能认为这样做有好办法,避免碰撞。

最佳回答

这是我决定采用的方法。

缩略语 如果假设0不复发,积极数值意味着X天的时间,消极数值意味着X个月的时间。

  • 0 : One time only
  • 1 : Every day
  • 7 : Every week
  • 14 : Every other week
  • -1 : Every month
  • -3 : Every 3rd month
  • -12 : Yearly
问题回答

暂无回答




相关问题
Java Checking number months

I think I figure out what question I am trying to ask I dont want get(Calendar.MONTH) I want the month not to be greater than the last caldendar month that is why i am doing month -1, i realize that ...

How to show custom events to a Kronolith calendar

I want to show events from an external source in the Kronolith calendar views. I don t want to do this by exporting the events to iCal and then showing them as an external calendar. The events are ...

How to reset a field when changing a date ui.datepicker.js

I m using ui.datepicker.js I have a form and when the date is changed I want that another field reset the status (this field is a dropdown select box). The case is the following: The user enter the ...

Calendar returns wrong month [duplicate]

Calendar rightNow = Calendar.getInstance(); String month = String.valueOf(rightNow.get(Calendar.MONTH)); After the execution of the above snippet, month gets a value of 10 instead of 11. How come?

How to determine if date/time is EDT or EST in Java?

I have a PDF that users must complete. The PDF has date and time fields on it. The PDF instructs the users to input the date and time in Eastern format (Not EST or EDT). When the user completes the ...

热门标签