Prayer&Petition

테이블 (9)

User (user)

  • user_id — Integer — 기본 키 — NOT NULL
  • email — String — NOT NULL
  • password — String — NOT NULL
  • phone_number (Field4)
  • nickname (Field5)
  • profile_image_url (Field6)
  • role_id (Field7)
  • location_id (Field8)
  • created_at (Field9)

권한 (role)

  • role_id (Field)
  • role_name (Field2)
  • description (Field3)

그룹 (group)

  • group_id (Field)
  • group_name (Field2)
  • description (Field3)
  • creator_id (Field4)
  • created_at (Field5)

그룹멤버 (group_membership)

  • membership_id (Field)
  • user_id (Field2)
  • group_id (Field3)
  • role (Field4)
  • joined_at (Field5)

기도제목 (prater_request)

  • request_id (Field)
  • user_id (Field2)
  • group_id (Field3)
  • title (Field4)
  • content (Field5)
  • visibility (Field6)
  • location_id (Field7)
  • is_completed (Field8)
  • created_at (Field9)
  • updated_at (Field10)

기도참여기록 (prater_log)

  • log_id (Field)
  • user_id (Field2)
  • request_id (Field3)
  • prayed_at (Field4)

연락처 (contact)

  • contact_id (Field)
  • owner_user_id (Field2)
  • phone_number (Field3)
  • created_at (Field4)

지역 (location)

  • location_id (Field)
  • location_name (Field2)
  • location_type (Field3)
  • parent_location_id (Field4)

친구관계 (friendship)

  • friendship_id (Field)
  • user1_id (Field2)
  • user2_id (Field3)
  • status (Field4)
  • created_at (Field5)