Help On Defining Relations

Yii 1.1 General Discussion
1

Hi All,

I have 3 tables:

member

id PK

memberNo

name

address

phone

membership

id PK

membershipNo

startDate

endDate

membership_group

id PK

memberFk FK to member(id)

membershipFk FK to membership(id)

joinDate

memo

The rule is 1 member can have 0…N membership. If he or she join membership, it will be stored on membership_group table.

My problem is,

  1. I have to define relationship from a member to membership, to display all memberships that a member ever joined.

  2. I also need a relationship from member to membership to show the latest membership he or she joined, membership is sorted by startDate.

Any one can help? Is it possible to have HAS_ONE and HAS_MANY at the same time?

Thanks in advance.

Daniel